Generated by All in One SEO Pro v5.0.0.1, this is an llms.txt file, used by LLMs to index the site. # DataTools Pro We build data tools for Salesforce and Snowflake data cloud ## Sitemaps - [XML Sitemap](https://datatoolspro.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Salesforce and Snowflake data cloud blog](https://datatoolspro.com/blog/) - Catch up with the latest in Salesforce and Snowflake world with DataTools Pro Blog. Your go-to resource for news, tips, and insights in the data realm. - [The Role of a Salesforce Metrics Dictionary in Promoting Team Cohesion](https://datatoolspro.com/how-a-salesforce-metrics-dictionary-improves-cross-organization-cohesion/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our The Role of a Salesforce Metrics Dictionary in Promoting Team Cohesion post to learn more! - [Snowflake CRM Record Matching & Lead Matchback](https://datatoolspro.com/snowflake-crm-record-matching-lead-matchback/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Snowflake CRM Record Matching & Lead Matchback post to learn more! - [DataTools Pro AI BI Blueprint](https://datatoolspro.com/datatools-pro-ai-bi-blueprint/) - Continuous refinement, process hacking has led to our DataTools Pro AI BI Blueprint. - [Snowflake CoWork: Building Your First AI Business Agent Prototype](https://datatoolspro.com/snowflake-cowork-building-your-first-ai-business-agent/) - With Snowflake CoWork, organizations have a new path to create AI-powered agents that understand natural language and provide answers directly from enterprise data. - [Adventures with Snowflake MCP and Semantic Views](https://datatoolspro.com/adventures-with-snowflake-mcp-and-semantic-views/) - Push real-world analytics use cases with Snowflake MCP and Snowflake Semantic Views. - [Building a Snowflake Semantic Layer in in 2026](https://datatoolspro.com/building-a-snowflake-semantic-layer-in-in-2026/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Building a Snowflake Semantic Layer in in 2026 post to learn more! - [Understanding Common AI BI Challenges that Slow Adoption](https://datatoolspro.com/understanding-common-ai-bi-challenges-that-slow-adoption-and-success/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Understanding Common AI BI Challenges that Slow Adoption post to learn more! - [AI BI Concepts you Should Understand for Success](https://datatoolspro.com/ai-bi-concepts-you-should-understand-for-success/) - AI BI magic happens when coupling the right people, prioritization, and processes around data, information management. - [Build with React in Salesforce : Compensation Management DataTools Conversion](https://datatoolspro.com/build-with-react-in-salesforce-compensation-management-datatools-conversion/) - Salesforce announced headless and multi-platform support, including React in Salesforce. We gave it a try and built our first prototype. - [My Token Spend is up 500%: What I learned to Manage Claude AI Cost​](https://datatoolspro.com/my-token-spend-is-up-500-what-i-learned-to-manage-claude-ai-cost/) - Here is what I learned to Claude AI Cost after token burn rate went up 500%. 5 tips to reduce your spend. - [Getting Started with Snowflake CoCo (Cortex Copilot)](https://datatoolspro.com/getting-started-with-snowflake-coco-cortex-copilot/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Getting Started with Snowflake CoCo (Cortex Copilot) post to learn more! - [Stress Testing Microsoft Copilot vs Claude vs ChatGPT](https://datatoolspro.com/stress-testing-microsoft-copilot-vs-claude-vs-chatgpt/) - Practical real world Microsoft Copilot vs Claude vs ChatGPT bakeoff in Excel and PowerPoint. - [Anatomy of a Modern AI Co-Pilot](https://datatoolspro.com/anatomy-of-a-modern-ai-co-pilot/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Anatomy of a Modern AI Co-Pilot post to learn more! - [The Tableau vs Power BI Rap Battle: So Cringy it's Addictive](https://datatoolspro.com/the-tableau-vs-power-bi-rap-battle/) - A mash up the classic data-geek debate of "Tableau vs Power BI" into an AI-powered rap battle. - [Solving Data Integration Problems Between Azure Data Factory and Salesforce](https://datatoolspro.com/data-integration-problems-between-azure-and-salesforce/) - Learn how DataTools Pro enhances Azure Data Factory with Salesforce integration, overcoming challenges and boosting efficiency for seamless data management. - [Testing Salesforce External Client App with our DataTools Portal](https://datatoolspro.com/testing-salesforce-external-client-app-with-our-datatools-portal/) - There have been so many changes to Salesforce connected apps in terms of integration and commercial requirements. Learn more - [Our Thanksgiving 2025 Anthem: The Data Song](https://datatoolspro.com/our-thanksgiving-2025-anthem-the-data-song/) - The Data Song will tell you something, and absolutely nothing about data at the same time! - [Worksheet User Alternatives to Snowflake Workspaces](https://datatoolspro.com/worksheet-user-alternatives-to-snowflake-workspaces/) - Alternative Snowflake Workspaces options for delivery to data workers and consumer roles. - [Why AI-Generated Meta-Data in Snowflake Semantic Views Can Be Dangerous](https://datatoolspro.com/why-ai-generated-meta-data-in-snowflake-semantic-views-can-be-dangerous/) - AI-Generated meta-data in Snowflake Semantic Views can be dangerous. Learn how to stay safe and accelerate forward. - [Lovable Vibe Coding: From Prototype to Production in 8 Hours](https://datatoolspro.com/lovable-vibe-coding-from-prototype-to-production-in-8-hours/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Lovable Vibe Coding: From Prototype to Production in 8 Hours post to learn more! - [Essential Salesforce Metrics & KPIs Guide](https://datatoolspro.com/essential-salesforce-metrics-kpis-guide/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Essential Salesforce Metrics & KPIs Guide post to learn more! - [DataTools Pro Spotlight: UTM Grabber](https://datatoolspro.com/datatools-pro-spotlight-utm-grabber/) - UTM Grabber is used by 100,000 websites to handle organic and paid web tracking, boasting over 30 attributes that can be passed from your Wordpress forms into Salesforce or a data warehouse. - [Solving the Multiple Versions of Truth Problem with Semantics](https://datatoolspro.com/solving-the-multiple-versions-of-truth-problem-with-semantics/) - Simple causes and solutions for multiple versions of truth and setting yourself on the right path to create a useful and correct semantic layer. - [When Metrics Don't Match: Building a Reliable Metrics Glossary in Salesforce](https://datatoolspro.com/building-reliable-metrics-glossary-salesforce/) - Learn how to establish and manage a metrics glossary in Salesforce. Improve data accuracy, support decision-making, and enhance cross-team collaboration. - [Troubleshooting Connection Issues With Your ADF Salesforce Connector](https://datatoolspro.com/connection-issues-adf-salesforce-connector/) - Learn to resolve common issues with your ADF Salesforce Connector using a step-by-step guide. Ensure smooth data integration with DataTools Pro. - [Prevent Snowflake Data Quality Problems during Snowflake Migration: Critical Safeguards](https://datatoolspro.com/snowflake-data-quality-during-snowflake-migration/) - Many businesses are embarking on a Snowflake migration. Snowflake is a powerful data warehouse that has expanded its reach as a full blown data platform. Snowflake data quality problems can arise during migration if the processes beyind your data platform are not carefully connsidered. .. Big moves, there's always the risk of running into challenges, - [Hubspot cohort analytics with Snowflake and Datameer](https://datatoolspro.com/hubspot-cohort-analytics-with-snowflake-and-datameer/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Hubspot cohort analytics with Snowflake and Datameer post to learn more! - [Fixing Relationship Errors in Your Salesforce Entity Relationship Diagram](https://datatoolspro.com/relationship-errors-salesforce-entity-relationship-diagram/) - Discover strategies to fix relationship errors in Salesforce Entity Relationship Diagrams. Enhance data accuracy and management with effective solutions. - [Developing a KPI Dictionary That Executives Actually Understand and Use](https://datatoolspro.com/developing-kpi-dictionary-that-executives-understand/) - Discover the steps to build an effective KPI dictionary that enhances understanding and strategic decisions for executives at every level. - [Replace Alteryx Self Service Chaos](https://datatoolspro.com/replace-alteryx-self-service-chaos/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Replace Alteryx Self Service Chaos post to learn more! - [DataTools Spotlight: Datameer is our Snowflake Tool of Choice](https://datatoolspro.com/snowflake-tool-of-choice/) - Accelerate your Snowflake Tool adoption with Datameer - the key to empowering analysts and eliminating tech debt. - [How DataTools Pro Resolves Cross-Department Communication Gaps](https://datatoolspro.com/datatools-pro-resolves-cross-department-communication-gaps/) - Discover how DataTools Pro helps resolve cross-department communication gaps in Salesforce for improved efficiency and collaboration across teams. - [Feeding Data from Facebook Ads to Snowflake](https://datatoolspro.com/feeding-facebook-ads-to-snowflake/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Feeding Data from Facebook Ads to Snowflake post to learn more! - [Which Data Tools Actually Improve Salesforce Reporting Performance?](https://datatoolspro.com/which-data-tools-actually-improve-salesforce-reporting-performance/) - Discover effective data tools to transform Salesforce reporting. Enhance data integration and decision-making with the right solutions from DataTools Pro. - [Why Is My Salesforce ERD So Confusing? Simple Solutions for Better Visualization](https://datatoolspro.com/salesforce-simple-solutions-for-better-visualization/) - how DataTools Pro eases Salesforce ERD challenges with intuitive tools and tips for better visualization and efficient data management. - [SQL Beginner Projects That Solve Real Business Problems](https://datatoolspro.com/sql-projects-that-solve-real-business/) - Learn SQL with beginner projects designed to resolve real business challenges. Discover how to manage data efficiently using DataTools Pro. - [Practical Skills Every SQL Analyst Needs for Salesforce Database Management](https://datatoolspro.com/practical-skills-every-sql-analyst-needs-for-salesforce-database-management/) - Master essential SQL skills for efficient Salesforce database management. Explore SQL analyst training to boost your prowess in data analytics. - [Overcoming Common Challenges in Salesforce Data Management](https://datatoolspro.com/common-challenges-in-salesforce-data-management/) - Learn how to overcome common Salesforce data management challenges with practical tools and strategies for better analytics. Read on! - [March Madness Bracket AI Bot: Busting Brackets](https://datatoolspro.com/bracket-ai/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our March Madness Bracket AI Bot: Busting Brackets post to learn more! - [Boosting Data Cloud Adoption with Salesforce](https://datatoolspro.com/data-cloud-adoption-salesforce/) - Learn how to enhance your data cloud strategy with Salesforce tools for efficient data management and analytics success. - [Agentic Brew: A Buzzed Neural Net’s Perfect Pint](https://datatoolspro.com/agentic-brew-a-buzzed-neural-nets-perfect-pint/) - Discover the story behind Agentic Brew, a unique beer born as a collaboration between DataTools Pro and Citizen Brewers in San Diego. - [Simplifying Salesforce Entity Relationships: A Brief Guide](https://datatoolspro.com/simplifying-salesforce-entity-relationship/) - Explore how to simplify and enhance Salesforce entity relationships for better data management and insights. - [TDX 2025: Salesforce Agentforce Gathering Recap](https://datatoolspro.com/tdx-2025-salesforce-agentforce-gathering-recap/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our TDX 2025: Salesforce Agentforce Gathering Recap post to learn more! - [Azure Snowflake Data Lake with Salesforce Data in a Few Clicks](https://datatoolspro.com/5-min-snowflake-data-lake-powered-by-azure-data-factory/) - In 5 minutes build a Snowflake Data Lake with Salesforce data using Azure Data Factory. - [Enhancing Analytics with Real-Time Data Monitoring](https://datatoolspro.com/enhancing-analytics-with-real-time-data-monitoring/) - Enhance decision-making with real-time data using powerful tools for optimizing Salesforce and Snowflake management, improving efficiency and business insights. - [Organizing Salesforce Data by Business Topics](https://datatoolspro.com/organizing-salesforce-data-by-business-topics/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Organizing Salesforce Data by Business Topics post to learn more! - [SQL vs SOQL for Salesforce: A Comprehensive Comparison](https://datatoolspro.com/sql-vs-soql/) - Salesforce professionals often working with data come to understand SQL vs SOQL. While both are used to query data, they serve distinct purposes. - [Improving Efficiency with Salesforce Data Mapping](https://datatoolspro.com/efficiency-with-salesforce-data-mapping/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Improving Efficiency with Salesforce Data Mapping post to learn more! - [Tracking Changes in Salesforce Data Dictionary](https://datatoolspro.com/tracking-changes-in-salesforce-data-dictionary/) - Learn how to track changes in Salesforce data dictionary to maintain data accuracy, consistency, and enhance business decision-making. - [Collaborating Across Teams in Salesforce with DataTools Pro](https://datatoolspro.com/salesforce-datatools-pro/) - Enhance team collaboration in Salesforce using DataTools Pro's features, metrics glossary, and more for efficient data management. - [Managing Reports and Dashboards in Salesforce: A Brief Guide](https://datatoolspro.com/managing-reports-and-dashboards-in-salesforce/) - Learn how managing Salesforce reports and dashboards boosts business efficiency with best practices and DataTools Pro's capabilities. - [Applied LLMs: Prompt Design Framework for Great Results](https://datatoolspro.com/prompt-design-framework/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Applied LLMs: Prompt Design Framework for Great Results post to learn more! - [Questions to build AI agent​s that are high impact](https://datatoolspro.com/questions-to-build-ai-agents-that-are-high-impact/) - Build AI Agent by focusing on your people, data, and processes to refine your skills. - [Streamlining Salesforce Data Migrations: Practical Methods to Try](https://datatoolspro.com/salesforce-data-migrations-practical-methods/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Streamlining Salesforce Data Migrations: Practical Methods to Try post to learn more! - [Effective Data Visualization with Salesforce ERD](https://datatoolspro.com/effective-data-visualization-with-salesforce-erd/) - Streamline data visualization with Salesforce ERDs. Discover tools and techniques to enhance clarity and team collaboration. Contact us! - [New Azure DataFactory template makes Salesforce to Snowflake Pipelines fast and cost-effective](https://datatoolspro.com/new-azure-datafactory-template-makes-salesforce-to-snowflake-pipelines-fast-and-cost-effective/) - Discover our new Azure DataFactory template, designed to accelerate Salesforce to Snowflake pipelines. Effective and cost-friendly solutions with DataTools Pro. - [Optimize Metrics Tracking in Salesforce](https://datatoolspro.com/optimize-metrics-tracking-in-salesforce/) - Enhance Salesforce metrics tracking easily. Discover strategies for accuracy and insights with DataTools Pro. - [Streamline Team Collaboration in Salesforce with DataTools Pro](https://datatoolspro.com/streamline-team-collaboration-in-salesforce/) - Boost Salesforce team collaboration with DataTools Pro's powerful features. Discover solutions for enhancing data analytics and teamwork efficiency. - [Keep Salesforce Documentation Up-to-Date Easily](https://datatoolspro.com/keep-salesforce-documentation-up-to-date/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Keep Salesforce Documentation Up-to-Date Easily post to learn more! - [Visualize Salesforce Object Relationships with Interactive ERD](https://datatoolspro.com/visualize-salesforce-object-with-interactive-erd/) - Discover how to visualize Salesforce object relationships using Interactive ERDs for better data insights and management. - [Boost Salesforce with Auto-Generated Entity Relationship Diagrams](https://datatoolspro.com/boost-salesforce-with-auto-generated-entity-relationship-diagrams/) - Learn how to boost Salesforce using auto-generated Entity Relationship Diagrams with DataTools Pro. Improve data visualization and efficiency. - [New DataTools Pro fights Salesforce zombie reports](https://datatoolspro.com/new-datatools-pro-fights-salesforce-zombie-reports/) - Reporting and Dashboard management DataTools for Salesforce. Clean up Salesforce zombie reports. - [Process hacking Gmail and Salesforce with Zapier And OpenAI](https://datatoolspro.com/gmail-and-salesforce-flow/) - A simple, streamlined GMail and Salesforce flow simplified to a single click, powered by Zapier and OpenAI LLMs - [Salesforce Entity Relationship Diagrams Makes Visual Storytelling Simple](https://datatoolspro.com/salesforce-entity-relationship-diagrams-make-visual-storytelling-made-simple/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Salesforce Entity Relationship Diagrams Makes Visual Storytelling Simple post to learn more! - [Why taking a SQL Course still matters in a world with AI](https://datatoolspro.com/why-a-sql-course-in-a-world-with-llms-still-matters/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Why taking a SQL Course still matters in a world with AI post to learn more! - [Why we love automating knowledge retention with Zapier and DataTools Pro](https://datatoolspro.com/why-love-automating-knowledge-retention-with-zapier-and-datatools-pro/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Why we love automating knowledge retention with Zapier and DataTools Pro post to learn more! - [What is Metrics Governance and why you need it](https://datatoolspro.com/what-is-metrics-governance-and-why-your-need-it/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our What is Metrics Governance and why you need it post to learn more! - [New Salesforce ERD DataTools Released](https://datatoolspro.com/new-salesforce-erd/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our New Salesforce ERD DataTools Released post to learn more! - [Salesforce Data Cloud is a Game Changer](https://datatoolspro.com/salesforce-data-cloud-is-a-game-changer/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Salesforce Data Cloud is a Game Changer post to learn more! - [Putting Salesforce Metadata To Work with New DataTools Pro](https://datatoolspro.com/putting-salesforce-metadata-to-work-with-new-datatools-pro/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Putting Salesforce Metadata To Work with New DataTools Pro post to learn more! - [Creating a Metrics Mind Map with DataTools Pro](https://datatoolspro.com/creating-a-metrics-mind-map-with-datatools-pro/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Creating a Metrics Mind Map with DataTools Pro post to learn more! - [Who Wins the Efficiency Game: Data Management vs AI Chatbots](https://datatoolspro.com/who-wins-the-efficiency-game-data-management-vs-ai-chatbots/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Who Wins the Efficiency Game: Data Management vs AI Chatbots post to learn more! - [March Madness: The Road to AI](https://datatoolspro.com/march-madness-the-road-to-ai/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our March Madness: The Road to AI post to learn more! - [Webinar Alert: Introducing DataTools Pro Metric Analyst for Salesforce](https://datatoolspro.com/webinar-alert-introducing-datatools-pro-metric-analyst-for-salesforce/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Webinar Alert: Introducing DataTools Pro Metric Analyst for Salesforce post to learn more! - [Analytics, Metrics and AI. Oh My!](https://datatoolspro.com/analytics-okrs-kpis-metrics-and-ai-oh-my/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Analytics, Metrics and AI. Oh My! post to learn more! - [Top Salesforce Data Cloud Resources for Learning](https://datatoolspro.com/top-salesforce-data-cloud-resources-for-learning/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Top Salesforce Data Cloud Resources for Learning post to learn more! - [DataTools Pro Beta3 is Here for the Holidays](https://datatoolspro.com/datatools-pro-beta3-is-here-for-the-holidays/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our DataTools Pro Beta3 is Here for the Holidays post to learn more! - [Webinar: Streamlining Data Migration to Salesforce in 2024 using Datameer and Snowflake](https://datatoolspro.com/webinar-alert-streamlining-data-migration-to-salesforce-using-snowflake-a-reverse-etl-data-stack/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Webinar: Streamlining Data Migration to Salesforce in 2024 using Datameer and Snowflake post to learn more! - [New ChatGPT Store is Proving Ground for DataTools Pro GPT](https://datatoolspro.com/new-chatgpt-store-is-proving-ground-for-datatools-pro-gpt/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our New ChatGPT Store is Proving Ground for DataTools Pro GPT post to learn more! - [New Microsoft Copilot Studio Custom Actions](https://datatoolspro.com/new-azure-copilot-studio-custom-actions/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our New Microsoft Copilot Studio Custom Actions post to learn more! - [Datameer is a Cutting Edge Solution for Snowflake Data Preparation](https://datatoolspro.com/salesforcemigration-qanda-2/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Datameer is a Cutting Edge Solution for Snowflake Data Preparation post to learn more! - [Salesforce Journey Map Tips for your Salesforce Marketing Cloud Strategy](https://datatoolspro.com/salesforce-journey-map-tips-for-your-salesforce-marketing-cloud-strategy/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Salesforce Journey Map Tips for your Salesforce Marketing Cloud Strategy post to learn more! - [Punch Well Above your Weight with Analytics as Service](https://datatoolspro.com/punch-well-above-your-weight-with-analytics-as-service/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Punch Well Above your Weight with Analytics as Service post to learn more! - [Salesforce Data Migration Tool Review](https://datatoolspro.com/salesforce-data-migration-tool/) - Free Salesforce data migration tool recommendations that will help you speed up your Salesforce.com data migration without spending any money. - [3 Common Salesforce.com Data Migration Issues to Avoid](https://datatoolspro.com/sfdc_migration_issues/) - Salesforce migration issues and pitfalls you want to avoid when moving data from your old app into Salesforce.com - [Salesforce.com Migration Research Q&A with ChatGPT](https://datatoolspro.com/salesforcemigration-qanda/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Salesforce.com Migration Research Q&A with ChatGPT post to learn more! - [Creating Snowflake UDFs with ChatGPT: A Guide for Analysts](https://datatoolspro.com/snowflake-udf/) - Get your Snowflake UDF (user defined functions) up and running no time, using the natural language processing capabilities of ChatGPT. - [How my Snowflake Powered Lead Distro Test Turned Out to be Reverse ETL](https://datatoolspro.com/snowflake-udf-2/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our How my Snowflake Powered Lead Distro Test Turned Out to be Reverse ETL post to learn more! - [Snowflake Warehouse Management with ROI in Mind](https://datatoolspro.com/snowflake-warehouse-management-with-roi-in-mind/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Snowflake Warehouse Management with ROI in Mind post to learn more! - [Snowflake and Microsoft Expand their Data and AI Partnership](https://datatoolspro.com/snowflake-and-microsoft-expand-their-data-and-ai-partnership/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Snowflake and Microsoft Expand their Data and AI Partnership post to learn more! - [Ultimate Salesforce and Snowflake Guide on Salesforce Ben](https://datatoolspro.com/ultimate-salesforce-and-snowflake-guide-on-salesforce-ben/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Ultimate Salesforce and Snowflake Guide on Salesforce Ben post to learn more! - [Salesforce Document Management And Attachment Export Made Easy](https://datatoolspro.com/salesforce-document-management-and-attachment-export-made-easy/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Salesforce Document Management And Attachment Export Made Easy post to learn more! - [Unlocking the Full Potential of MLOps with Snowflake and Predactica](https://datatoolspro.com/unlocking-the-full-potential-of-mlops-with-snowflake-and-predactica/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Unlocking the Full Potential of MLOps with Snowflake and Predactica post to learn more! - [Exciting New Native Salesforce Snowflake Integration](https://datatoolspro.com/new-horizons-in-data-strategy-the-freshly-launched-salesforce-snowflake-integration/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Exciting New Native Salesforce Snowflake Integration post to learn more! - [Your 2024 Tableau Salesforce Integration Guide](https://datatoolspro.com/your-2024-tableau-salesforce-integration-guide/) - Imbibe knowledge from Salesforce Data Analytics Experts via DataTools Pro Blog. Read our Your 2024 Tableau Salesforce Integration Guide post to learn more! ## Pages - [New Data Tools for Salesforce and Snowflake](https://datatoolspro.com/) - We build data tools that transforms Salesforce and Snowflake data into decision intelligence. DataTools Pro for Salesforce and Snowflake builds metrics and semantics for analytics. - [Salesforce data migration 2026 - A Blueprint that is AI Ready](https://datatoolspro.com/salesforce-migration-services/salesforce-data-migration/) - We have solved the hard migration problems and found AI shortcuts to save you a lot of time. - [Services](https://datatoolspro.com/services/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Services page to learn more. - [Snowflake Native Apps by DataTools Pro](https://datatoolspro.com/services/snowflake-native-apps-datatools-pro/) - We design and build Snowflake Native Apps — data products and analytics tools that run directly inside your customers' Snowflake accounts without data ever leaving the warehouse. - [DataTools Pro Builds Secure, Scalable Salesforce OAuth & Authentication](https://datatoolspro.com/services/salesforce-oauth-authentication-services-datatools-pro/) - We build secure Salesforce OAuth and authentication layers — External Client Apps, Named Credentials, JWT bearer flows, and token management built for production integrations. - [Your Analytics Strategy Playbook is Clicks Away](https://datatoolspro.com/analytics-strategy/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Your Analytics Strategy Playbook is Clicks Away page to learn more. - [Tableau Cloud Services — Setup, Governance & Automated QA | DataTools Pro](https://datatoolspro.com/services/tableau-cloud-services-setup-governance-automated-qa-datatools-pro/) - We deliver Tableau Cloud setup, MCP configuration, analytics governance, and automated quality assurance — so your team gets reliable dashboards and consistent metrics with minimal manual work. - [Stop Manually Updating Your CRM - Let Claude AI Do It | DataTools Pro](https://datatoolspro.com/services/stop-manually-updating-your-crm-let-claude-ai-do-it-datatools-pro/) - We build conversational CRM automation using Claude AI, Zapier, and your Laravel API so your team can read, create, and update CRM records through natural language with no manual data entry. - [Salesforce Data Migration Services Blueprint for Success](https://datatoolspro.com/salesforce-migration-services/) - We specialize in migrating in and out of Salesforce. We provide specialized tools services and blueprints for Salesforce data migrations. - [Salesforce AI Workflow Integration Services | DataTools Pro](https://datatoolspro.com/services/salesforce-ai-workflow-integration-services-datatools-pro/) - We design and build Salesforce systems for AI-powered workflows — agentic automation, OpenAI integration, Einstein AI, and intelligent sales and support processes built for production. - [Salesforce API & Middleware Development Services | DataTools Pro](https://datatoolspro.com/services/salesforce-api-middleware-development-services-datatools-pro/) - We build secure Salesforce API and middleware layers REST, Bulk and Streaming API, data transformation, and ERP integrations that connect Salesforce to your entire technology stack. - [Salesforce Administration Services | DataTools Pro](https://datatoolspro.com/services/salesforce-administration-services-datatools-pro/) - Expert Salesforce administration services — user management, Flow automation, permission sets, and org health reviews for growing teams. Ongoing and project-based engagements available. - [Laravel + Salesforce Portal Development Services | DataTools Pro](https://datatoolspro.com/services/laravel-salesforce-portal-development-services-datatools-pro/) - We build Laravel and Salesforce connected portals — customer portals, partner portals, and internal tools with SSO, RBAC, and real-time Salesforce sync. No Experience Cloud costs. - [Tableau to Salesforce Automation](https://datatoolspro.com/services/tableau-to-salesforce-automation/) - We build Tableau to Salesforce automation pipelines using External Actions and Salesforce Flows add leads to campaigns, trigger workflows, and write data back to CRM automatically. - [Laravel to Salesforce Integration Services | DataTools Pro](https://datatoolspro.com/services/laravel-to-salesforce-integration-services-datatools-pro/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Laravel to Salesforce Integration Services | DataTools Pro page to learn more. - [PostHog Analytics Services | Implementation & Consulting – DataTools Pro](https://datatoolspro.com/services/posthog-analytics-services-implementation-consulting-datatools-pro/) - Expert PostHog setup, implementation, and consulting for SaaS teams. We handle event tracking, session recording, and PostHog integration with your existing data stack — so you get clean analytics from day one. - [Prompt Libs - Learn to Write AI Prompts like a Pro](https://datatoolspro.com/prompt-libs/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Prompt Libs – Learn to Write AI Prompts like a Pro page to learn more. - [Privacy](https://datatoolspro.com/privacy/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Privacy page to learn more. - [Snowflake Adoption Blueprint Speeds up Time to Value](https://datatoolspro.com/snowflake-adoption-blueprint-speeds-up-time-to-value/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Snowflake Adoption Blueprint Speeds up Time to Value page to learn more. - [Data Tools Shop](https://datatoolspro.com/data-tools-library/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Data Tools Shop page to learn more. - [Metrics Glossary AI: Business Semantics Management](https://datatoolspro.com/business-semantics-management/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Metrics Glossary AI: Business Semantics Management page to learn more. - [Contact](https://datatoolspro.com/contact/) - Have data management queries in Salesforce? Contact DataTools Pro today. We're all set to assist you with our expert tools and analytics solutions. Book now! - [DataTools for Salesforc Pricing](https://datatoolspro.com/datatools-for-salesforce/datatools-for-salesforce-pricing/) - Bring your team on board with DataToolsPro, offering competitive DataTools pricing optimized for teams and enterprise-level operations. Explore today! - [Executive insights and data influenced decisions with DataTools Pro](https://datatoolspro.com/executive-datatools/) - Drive your business growth with DataTools Pro. Offering advanced tools for managing executive metrics and KPIs with high precision and efficiency. Learn more. - [Terms of Service](https://datatoolspro.com/terms/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Terms of Service page to learn more. - [Salesforce Admin Data Tools](https://datatoolspro.com/salesforce-admin-data-tools/) - Revolutionizing productivity with our Salesforce Admins DataTools. Choose DataTools Pro for agile, efficient Salesforce administration and operation. - [DataTools Pro for Snowflake- Increase Adoption and Improve Value](https://datatoolspro.com/snowflake/) - DataTools Pro for Snowflake provides plug and play value creation for your investments in Snowflake as your data platform of choice. - [Support - DataTools Pro](https://datatoolspro.com/support/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Support – DataTools Pro page to learn more. - [4 Steps to Perfect your Web to lead Salesforce Process](https://datatoolspro.com/web-to-lead-salesforce/) - Build the right web to lead Salesforce solution with clean data, consistent process, and clear visibility into your Salesforce funnel - [Data Tools Tutorials and Docs](https://datatoolspro.com/tutorials-2/) - Data Tools Pro Tutorials and Docs page is your hub for free resources to learn our preferred tools and platforms including Salesforce Data Migration, Snowflake, Datameer, and Azure. - [DataToolsPro Data Security FAQ](https://datatoolspro.com/datatoolspro-data-security-faq/) - DataToolsPro security FAQ outlines specific product design considerations and questions with the goal to provide clear and transparent explanation how we use your meta-data to deliver value. - [About Data Tools Pro Team](https://datatoolspro.com/about-data-tools-pro/) - Embark on a journey with DataTools Pro Team, your companion in the Salesforce universe. We are ERD experts committed to elevating your data experience. - [Muhammad Waqar Ahmad Khan](https://datatoolspro.com/about-data-tools-pro/muhammad-waqar-ahmad-khan/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Muhammad Waqar Ahmad Khan page to learn more. - [Tableau to Power BI Migration Made Easy with BIChart](https://datatoolspro.com/tableau-to-power-bi-migration/) - We work with BIChart to automate Tableau to Power BI migration initiatives. - [Migrate Alteryx: Simple and Fast Migration to Alteryx Alternatives](https://datatoolspro.com/migrate-alteryx/) - We specialize in helping enterprise migrate Alteryx. Migrate Alteryx to modern data cloud platforms thanks to proprietary data tools. - [Lightning Fast Return Mail Scanner and Analysis](https://datatoolspro.com/return-mail-analysis/) - Returnzilla return mail scanner app turns your return mail into data using AI computer vision. Get started for free. - [Analytics Migration Blueprints](https://datatoolspro.com/analytics-migration-blueprints/) - DataTools Pro analytics migration and consolidation blueprint will connect a proven process with an experienced team, and the right tools for the job - [DataTools Pro Partners](https://datatoolspro.com/partners/) - At DataTools Pro, we team up with technology and service providers who share our obsession with customer success. DataTools Pro Partners page to learn more. - [Ryan Goodman](https://datatoolspro.com/about-data-tools-pro/ryan-goodman/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Ryan Goodman page to learn more. - [Cookie Policy](https://datatoolspro.com/cookie-policy/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Cookie Policy page to learn more. - [DataTools Pro Feedback](https://datatoolspro.com/datatools-pro-feedback/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our DataTools Pro Feedback page to learn more. - [DataTools Pro Release Notes](https://datatoolspro.com/release-notes/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our DataTools Pro Release Notes page to learn more. - [Confirmation](https://datatoolspro.com/confirmation/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Confirmation page to learn more. - [Convert Alteryx to SQL Matrix](https://datatoolspro.com/alteryx-to-sql-matrix/) - Alteryx to SQL Matrix is a practical reference tool teams migrating from Alteryx to Snowflake. - [Datameer Data Preparation and Wrangling for Snowflake](https://datatoolspro.com/datameer-3/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Datameer Data Preparation and Wrangling for Snowflake page to learn more. - [DataTools for Salesforce and Salesforce Data Cloud](https://datatoolspro.com/datatools-for-salesforce/) - Elevate your data game with DataToolsPro. Unravel robust data tools specifically designed for Salesforce and Data Cloud professionals. Connect today! - [Enhance Your Salesforce Expertise: SQL for Salesforce Course](https://datatoolspro.com/sql-for-salesforce/) - Embark on a journey of enlightenment with our comprehensive SQL analyst training tailored for Salesforce users. Let us guide your data learning voyage. - [DataTools Doctors: Quick Fixes, Expert Solutions, No Hassle](https://datatoolspro.com/datatools-doctors/) - Optimize your data regime with DataTools Doctors. We fine-tune Azure Data Factory for seamless Salesforce integration to supercharge your operations. - [Datameer Data Preparation, Profiling, and Wrangling for Snowflake](https://datatoolspro.com/datameer-2/) - Offering Datameer Data Preparation, Profiling, and Wrangling for Snowflake. DataTools Pro turns data chaos into clearly understandable information. Learn more. - [DataTools Pro Services Solution Briefing](https://datatoolspro.com/datatools-pro-services-solution-briefing/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our DataTools Pro Services Solution Briefing page to learn more. - [Connect Zapier to DataTools Pro](https://datatoolspro.com/zapier-to-datatools-pro/) - Making data management a breeze with our seamless Zapier integration. Choose DataTools Pro for dynamic, efficient data processing and management. Learn more. - [DataTools Pro Integrations for Metrics Governance](https://datatoolspro.com/integrations/) - Accelerate your metrics management with fast DataTools integration by DataTools Pro. Experience superior metric governance across diverse platforms. - [New 2025 Salesforce data migration tool](https://datatoolspro.com/salesforce-migration-app/) - Unleash your data's potential with our powerful Salesforce Migration App. DataToolsPro paves the way for efficient data mapping and migration. Learn more. - [Free Smart Salesforce Dictionary Data Tools](https://datatoolspro.com/salesforce-dictionary-app/) - Empower your data mapping with our smart Salesforce dictionary app. DataTools Pro, dedicated to helping you comprehend reports and metrics with ease. - [Manage your Salesforce Reports and Dashboards like a Pro!](https://datatoolspro.com/manage-your-salesforce-reports-and-dashboards/) - Redefine your Salesforce dashboard management with our advanced tool. DataTools Pro offers sophisticated features to streamline your reports. Consult now! - [How to Create Salesforce Entity Relationship Diagram](https://datatoolspro.com/connected-salesforce-entity-relationship-diagram/) - Revolutionize data management with our trusted Salesforce ERD Tool. DataToolsPro simplifies complexities to propel your roadmap to success. Get started today! - [Smart Salesforce Metrics Glossary in a Few Clicks](https://datatoolspro.com/salesforce-metrics-glossary/) - Navigate Salesforce & Tableau with confidence using our Centralized Metrics Glossary. DataTools Pro - your one-stop for data tool knowledge. Contact now! - [Purchase SQL for Salesforce Course](https://datatoolspro.com/sql-for-salesforce/checkout/) - Purchase SQL for Salesforce by DataTools pro. Jumpstart your self paced introductory training to SQL using Snowflake. - [My DataTools Courses: Results Focused Training](https://datatoolspro.com/my-courses/) - DataTools courses are built to help you deliver results to your enterprise. Upskill your data wrangling, analytics, and data literacy skills. - [Log In](https://datatoolspro.com/login/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Log In page to learn more. - [Registration](https://datatoolspro.com/registration/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Registration page to learn more. - [Free Sign up for DataTools Pro](https://datatoolspro.com/beta/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Free Sign up for DataTools Pro page to learn more. - [ADF Pipeline Confirmation Signup](https://datatoolspro.com/adf-pipeline-confirmation/) - Thanks for signing up for our free ADF template! - [Courses](https://datatoolspro.com/courses/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Courses page to learn more. - [Profile](https://datatoolspro.com/profile-2/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Profile page to learn more. - [Reset Password](https://datatoolspro.com/reset-password/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Reset Password page to learn more. - [Registration Success](https://datatoolspro.com/registration-success/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Registration Success page to learn more. - [Manage Metrics from Google Analytics 4 with DataTools Pro](https://datatoolspro.com/metrics-from-google-analytics/) - Document and manage your metrics from Google Analytics 4 with DataTools Pro. - [DataTools Pro Coda Bundle Metrics Glossary](https://datatoolspro.com/datatools-pro-coda-bundle/) - DataTools Pro Coda Bundle delivers your metrics glossary to more team members across your organization. - [DataTools Pro Notion Integration and Templates](https://datatoolspro.com/datatools-pro-notion-integration-and-templates/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our DataTools Pro Notion Integration and Templates page to learn more. - [Data Tools Pro Sign Up Confirmation Mailing](https://datatoolspro.com/sign-up-confirmation-mailing/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Data Tools Pro Sign Up Confirmation Mailing page to learn more. - [Meeting Confirmation](https://datatoolspro.com/contact/meeting-confirmation/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Meeting Confirmation page to learn more. - [Manage Metrics for Tableau Pulse with DataTools Pro](https://datatoolspro.com/metrics-for-tableau-pulse/) - Enhance your metrics for Tableau Pulse experience by relating, consolidating, and documenting them with more context to your organization - [Webinars and Videos](https://datatoolspro.com/webinars/) - Webinars and videos from DataTools Pro team provides thought leadership and technology expertise that you can take back to your enterprise. - [DataTools Pro Documentation](https://datatoolspro.com/documentation/) - DataTools Pro for Salesforce documentation, tutorials, and learning paths. - [Webinars Confirmation](https://datatoolspro.com/webinar-confirmation/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Webinars Confirmation page to learn more. - [DataTools Pro Checkout](https://datatoolspro.com/datatools-checkout/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our DataTools Pro Checkout page to learn more. - [Verify otp](https://datatoolspro.com/verify-otp/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Verify otp page to learn more. - [Contact - Datameer Demo](https://datatoolspro.com/contact-datameer-2/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Contact – Datameer Demo page to learn more. - [Salesforce Migration Assessment](https://datatoolspro.com/salesforce-migration-services/salesforce-migration-assessment/) - Salesforce Data Migration Assessment provides a detailed Salesforce Data Migration overview and recommendations for success. - [Online Salesforce Data Migration Assessment](https://datatoolspro.com/salesforce-migration-services/online-salesforce-data-migration-assessment-v2/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Online Salesforce Data Migration Assessment page to learn more. - [Salesforce Data Migration Checklist](https://datatoolspro.com/salesforce-migration-services/salesforce-migration-checklist/) - Detailed Salesforce data migration checklist captures everything you need to size the time and effort needed to move your data. - [Salesforce Data Migration Infographic](https://datatoolspro.com/salesforce-data-migration-infographic/) - Salesforce Data Migration Infographic with 10 step countdown to your Salesforce.com launch. Learn how to properly sequenced and resource your data migration for a successful Salesforce.com launch. - [Salesforce Migration Checklist Confirmation](https://datatoolspro.com/salesforce-migration-services/salesforce-migration-checklist-confirmation/) - DataTools Pro, your trusted partner for comprehensive Salesforce Data Analytics Services. Visit our Salesforce Migration Checklist Confirmation page to learn more. ## Tutorials - [Install and Setup Snowflake MCP with Claude](https://datatoolspro.com/tutorials/install-and-setup-snowflake-mcp/) - This tutorial was written for local testing and experimentation of Snowflake MCP with Claude using the latest Snowflake-hosted MCP service. Snowflake supports MCP without needing to install the server locally and Claude offers a cloud native connection from Claude to Snowflake. These two upgrades in 2026 put data in Snowflake in your Claude AI analysts - [Activating Snowflake AI BI Agents with Claude](https://datatoolspro.com/tutorials/activating-snowflake-ai-bi-agents-with-claude/) - Over the last 3 months, we have had significant breakthroughs in terms of accuracy, adoption, and value using Snowflake AI BI Agents with Claude. Now, BI is grounding for AI, and AI helps work through the next wave of BI dashboards when new signals and initiatives are created. For this article, we ignore developer/builder workstreams - [Setup Snowflake OAuth for MCP for Claude Snowflake Connector](https://datatoolspro.com/tutorials/setup-snowflake-oauth-for-mcp-for-claude-snowflake-connector/) - Snowflake OAuth for MCP lets you connect the Claude Snowflake Connector using secure, token-based authentication. By creating a custom OAuth client in Snowflake and linking it to MCP, you can avoid storing passwords and keep access tied to Snowflake’s built-in roles and permissions. View article: Install and Set Up Snowflake MCP with Claude Snowflake Configuration - [Import Data Into Salesforce with Azure Data Factory](https://datatoolspro.com/tutorials/import-data-into-salesforce-with-azure-data-factory/) - Recent Articles about Azure Data Factory - [Free Salesforce Data pipelines to Snowflake with ADF](https://datatoolspro.com/tutorials/salesforce-data-pipelines/) - Our Azure DataFactory template as a free resource that automates Salesforce Data pipelines to Snowflake in minutes, with a meta-data driven approach. - [Configure Azure Data Factory for Salesforce 2026](https://datatoolspro.com/tutorials/azure-data-factory-for-salesforce/) - In this tutorial we will configure Azure Data Factory for Salesforce using the new connector configuration released in January 2024. - [Extension: Tableau Dynamic Measure Picker](https://datatoolspro.com/tutorials/extension-tableau-dynamic-measure-picker/) - Measure Picker allows you to create a Tableau dynamic measure with a dashboard extension. Get started for free! - [DataTools Pro Explorer for Snowflake Release Notes](https://datatoolspro.com/tutorials/datatools-pro-explorer-for-snowflake-release-notes/) - Request enhancements directly to our support team. Our team replies to 100% of the requests. View Product details | DataTools Pro Explorer Documentation | Snowflake Marketplace Listing Have an enhancement or bug fix? Send us an email to support@datatoolspro.com. Existing users are top priority for enhancements. Dec 2025 Release Automated persistence "last query" across sessions - [DataTools Pro Explorer for Snowflake Documentation](https://datatoolspro.com/tutorials/datatools-pro-explorer/) - Overview DataTools Pro Explorer for Snowflake is a simple data exploration tool to aggregate, filter, and sort data quickly while generating SQL code for you. DataTools Pro Explorer allows you to explore Snowflake tables and views. Our goal is to enable users of all skill levels to quickly analyze large volumes of data inside Snowflake, - [Setting up and running Tableau MCP with Claude](https://datatoolspro.com/tutorials/setting-up-and-running-tableau-mcp-with-claude/) - Tableau MCP (Model Context Protocol) lets you integrate large language models directly into Tableau. I am looking to use Claude to assist me as an AI QA engineer to check the work of report builders. With MCP, Tableau can pass structured context, metadata, and query details to a large language model, allowing Claude to analyze - [Authorizing an DataTools Pro as an Installed Connected App](https://datatoolspro.com/tutorials/authorizing-an-salesforce-uninstalled-app/) - Effective September 2025 Salesforce is rolling out new security requirements for Connected Apps starting September 2025. These changes are designed to strengthen data protection and prevent unauthorized apps from accessing your Salesforce environment. If your organization uses DataTools Pro, action may be required to avoid interruptions. What’s Changing Salesforce is tightening enforcement around uninstalled connected - [DataTools Pro Getting Started Guide](https://datatoolspro.com/tutorials/datatools-pro-getting-started-guide/) - Get started managing and analyzing your metadata with DataTools Pro - [Salesforce OAUTH_APPROVAL_ERROR_GENERIC: Solved](https://datatoolspro.com/tutorials/salesforce-oauth_approval_error_generic/) - Are you trying to log in with Salesforce and seeing this error? OAUTH_APPROVAL_ERROR_GENERIC You are not alone, as Salesforce implemented several security control measures in October 2025, intended to slow the number of bad actors abusing OAuth-connected applications. Here is an official Salesforce blog highlighting the change. "We can't authorize you because of an OAuth - [Salesforce Admin DataTools Pro Install Guide](https://datatoolspro.com/tutorials/salesforce-admin-install-guide/) - We created this article to explain DataTools Pro connected app, updated with the latest Salesforce requirements for connected apps. DataTools Pro was built to extend the value of Salesforce metadata to non-Salesforce admins. These are data, analytics, and product owners who need to understand and access Salesforce metadata as part of their job. If you - [How to Configure Salesforce Connected Apps for Non Salesforce Admin Users](https://datatoolspro.com/tutorials/how-to-configure-salesforce-connected-apps-for-non-salesforce-admin-users/) - Salesforce has recently implemented stricter security measures around OAuth and Connected Apps to protect users from social engineering and unauthorized access. These changes affect how third-party apps, including DataTools Pro, connect to Salesforce environments. While the update enhances overall security and governance, it introduces new steps and approvals for administrators and users to configure and - [Security Policy - Salesforce Connected App](https://datatoolspro.com/tutorials/security-policy-salesforce-connected-app/) - This page explains how DataTools Pro protects your data and keeps our Salesforce AppExchange solutions secure and available. Last updated: 2025-10-10 Our Commitment Security by design across the full software lifecycle. Privacy first: we collect the minimum required to operate the service. Transparency: clear documentation, responsible disclosure, and uptime reporting. What We Operate Products: Salesforce - [Visual SQL Builder by DataTools Pro](https://datatoolspro.com/tutorials/visual-sql-builder-by-datatools-pro/) - Overview DataTools Pro Visual SQL Builder is a no-code visual SQL builder designed specifically for Snowflake users. It helps analysts, business users, and data teams quickly create and run queries without needing to write complex SQL. With an intuitive Streamlit-based interface, DataTools Pro Visual SQL Builder accelerates analysis and democratizes access to data across your - [Completing DataTools Pro Install Process](https://datatoolspro.com/tutorials/completing-datatools-pro-install-process/) - [Setup Datameer in Snowflake](https://datatoolspro.com/tutorials/setup-datameer-in-snowflake/) - Setup Datameer role, permissions and Snowflake authentication - [Implementing a Snowflake Aggregation Policy (the practical way)](https://datatoolspro.com/tutorials/implementing-a-snowflake-aggregation-policy-the-practical-way/) - A Snowflake Aggregation Policy lets you force queries to return only aggregated results. - [Setting Up Snowflake Semantic Views](https://datatoolspro.com/tutorials/setting-up-snowflake-semantic-views/) - Snowflake Semantic Views as a business‑focused abstraction layer layered on top of physical tables. They let you define logical tables like customers, orders, or suppliers that encapsulate consistent definitions for facts, metrics, and dimensions. These are the building blocks for Business Intelligence: Facts are the granular, row‑level numeric details (like “quantity sold”) used to build - [Stage and Load Data from S3 into Snowflake](https://datatoolspro.com/tutorials/stage-and-load-data-from-s3-into-snowflake/) - If you plan to load data from an AWS S3 stage into Snowflake, it requires configuration steps for the following services. The official, up to Snowflake S3 documentation is short and vague if you want a secure stage. We cover both products so you your AWS and Snowflake admins can have a complete, secure configuration. - [Protecting Customer Privacy with Snowflake Aggregation Policies](https://datatoolspro.com/tutorials/protecting-customer-privacy-with-snowflake-aggregation-policies/) - Preventing Access to Individual Records Without Losing Insight We were very excited to learn about Snowflake’s aggregation policies, allowing us to globally protect our customers from exposing individual records, which are rarely needed for most analytics cases. If you’re working with tables that contain customer PII, and you want to prevent anyone from slicing down - [Install Python for MCP Server](https://datatoolspro.com/tutorials/install-python-for-mcp-server/) - Before you install Python, you may need administrative access to your server. Download "Python 3.12.x" (latest version). Run the EXE IMPORTANT: Check "Add python.exe to PATH" Click Install Now Open PowerShell on your windows computer. Run the following scripts python --version # Should show: Python 3.12.x pip --version # Should show: pip x.x.x Install UV - [Tableau Desktop login redirect to Salesforce SSO](https://datatoolspro.com/tutorials/tableau-desktop-login-redirect-to-salesforce-sso/) - When toggling between Tableau cloud orgs where Salesforce SSO may not be enabled for users or entire businesses you may find yourself stuck! Tableau desktop opens and when you open the Server menu, it will autofill your Salesforce user and advances to the next page. At that point you can't get back to log in - [Tableau to Snowflake OAuth Security Setup](https://datatoolspro.com/tutorials/tableau-to-snowflake-oauth-security/) - In this article we will explore setting up Tableau to Snowflake OAuth, when to user it, and how to embed your OAuth credentials. Connecting Tableau to Snowflake historically was achieved with end user passwords or system users where credentials could be embedded.In 2025 you will be required to use a federated login via Okta, Key - [Salesforce Object Exploration and Discovery](https://datatoolspro.com/tutorials/salesforce-object-exploration-and-discovery/) - Entity management and relationship management in Salesforce has long been treated as a bottoms up design process. However, we understand that all too often entity relationships are not understood and require exploration and discovery. That is why we created our entity discovery feature, allowing you to understand relationships of objects at a glance. Simply clicking - [Convert Alteryx to SQL Snowflake: A Complete Guide](https://datatoolspro.com/tutorials/convert-alteryx/) - Looking to Convert Alteryx to SQL efficiently? Check out our guide on leveraging Snowflake's cloud-native architecture for optimized ETL workflows and analytics - [Snowflake Key Pair Authentication: 3 Easy Steps](https://datatoolspro.com/tutorials/snowflake-key-pair-authentication/) - Snowflake key pair authentication is used to authenticate data and analytics tools into Snowflake securely. - [Storing Snowflake Key Pair in Azure Key Vault](https://datatoolspro.com/tutorials/azure-key-vault/) - Store the Private Key in Azure Key Vault After you have generated a public and private key pair, you can securely store the private keys in Azure Key Vault. 2.1 Upload the Private Key as a Secret Go to Azure Portal → Open Azure Key Vault. In the left panel, go to Secrets → Click - [Create HubSpot Private App API Connection for Data Tools](https://datatoolspro.com/tutorials/hubspot-private-app/) - In this tutorial we will explore creating a Hubspot private app for internal use with data tools like Azure DataFactory or our DataTools Pro. Hubspot does a great job providing practical scopes for accessing meta-data, data, and sensitive data. There are many different types of data and analytics tools, so building your internal app with - [HubSpot to Azure DataFactory Linked Service](https://datatoolspro.com/tutorials/hubspot-to-azure-datafactory-linked-service/) - In this tutorial we will configure HubSpot to Azure DataFactory Linked Service for purposes of extracting data. Hubspot does a great job providing practical scopes for accessing meta-data, data, and sensitive data. There are many different types of data and analytics tools, so building your internal app with a least privilege principles is very important. - [Connect Azure Data Factory to Snowflake](https://datatoolspro.com/tutorials/connect-azure-data-factory-to-snowflake/) - By following this step-by-step guide, you'll be able to connect Azure Data Factory to Snowflake. As a result you can transfer data between the two platforms. - [Create a Snowflake Data Source in Azure Data Factory](https://datatoolspro.com/tutorials/create-a-snowflake-data-source-in-azure-data-factory/) - In this example, we will guide you through the process to create a Snowflake Data Source in Azure Data Factory. This is an important building block for building data pipelines. - [Azure Data Factory to Snowflake Key Pair](https://datatoolspro.com/tutorials/azure-data-factory-to-snowflake-key-pair/) - In this article we will connect Azure Data Factory to Snowflake using key pair authentication. 1. In ADF, go to Manage → Linked services. 2. Click + New → Choose Snowflake. Set Azure ADF Properties for Snowflake Warehouse: Your Snowflake warehouse name Connection Type: Key Pair Authentication Learn how to setup Snowflake Key Pair Authentication - [Understanding Snowflake User Types](https://datatoolspro.com/tutorials/snowflake-user-types/) - Snowflake has introduced a game-changing feature: the TYPE property for the USER object. This long-awaited update allows us to easily classify human users and service accounts, eliminating the need for manual tagging. Why Snowflake user type matters Security is a top priority, and the ability to distinguish between user types helps enforce better authentication policies - [1Password Token Management: How we keep client credentials secure](https://datatoolspro.com/tutorials/1password-token-management/) - At DataTools Pro we have selected 1Password as our key vault solution given its portability and protection measures that allow us to: 1. Secure client credentials 2. Isolate vaults 3. Securely share tokens with 2 factor authentication 1Password is not limited to logins. You can save other sensitive data including but not limited to the - [Master SOQL for Salesforce](https://datatoolspro.com/tutorials/soql/) - Master the art of writing SOQL queries like a pro with this comprehensive guide. Discover the key components and syntax for crafting efficient queries in Salesforce. - [Adding Multiple Salesforce orgs into DataTools Pro](https://datatoolspro.com/tutorials/adding-multiple-salesforce-orgs-into-datatools-pro/) - In DataTools Pro, you can add multiple Salesforce orgs in Settings. Go to Settings Click on Add Instance Click "Login with Salesforce" Login to your Salesforce org Objects are visible and available within your org Using multiple orgs in DataTools Pro Data Migration The current supported tools for using multiple Salesforce orgs is data migration. - [SOQL SELECT All Fields: How to Retrieve Every Field in Salesforce](https://datatoolspro.com/tutorials/soql-select-all-fields/) - SOQL SELECT ALL fields is requiers some planning when working with Salesforce Object Query Language (SOQL). Often you need to retrieve all fields from a Salesforce object. Unlike SQL, SOQL does not support the traditional SELECT * syntax to fetch all columns from an object. However, there are workarounds to achieve this efficiently. In this - [SOQL ORDER BY: Guide to Sorting your Salesforce Queries](https://datatoolspro.com/tutorials/soql-order-by/) - SOQL ORDER BY allows you to sort query results efficiently using Salesforce Object Query Language (SOQL). 1. Basic Syntax of SOQL ORDER The ORDER BY clause is used to sort records based on a specified field in either ascending (ASC) or descending (DESC) order. Syntax: SELECT Field1, Field2 FROM ObjectName ORDER BY FieldName ASC | - [SOQL NOT LIKE: Filtering Out Unwanted Data](https://datatoolspro.com/tutorials/soql-not-like/) - SOQL Not Like is not supported by Salesforce, requiring alternative methods to exclude specific patterns from query results. Salesforce does in fact supports the LIKE operator, which allows pattern matching using the % wildcard (representing zero or more characters) and _ (representing a single character). For example: SELECT Name FROM Account WHERE Name LIKE 'Acme%' - [Setting Up a Snowflake User Network Policy IP Whitelist](https://datatoolspro.com/tutorials/snowflake-user-network-policy/) - When setting up a Snowflake user network policy IP whitelist with Azure Data Factory in production, you are allowing secured traffic between Azure and Snowflake for a specific system user. - [Connect Azure Data Factory to Salesforce](https://datatoolspro.com/tutorials/connect-azure-data-factory-to-salesforce/) - In this example, we will guide you through the process to connect Azure Data Factory to Salesforce using a linked service - [Setup Snowflake Role Based Access for Success](https://datatoolspro.com/tutorials/snowflake-role-based-access/) - Snowflake Role Based Access (RBAC) allows you to manage permissions efficiently by assigning access based on roles and responsibilities rather than individual users. - [Understanding Snowflake’s Newer Network Security Model: Network Rules & Policies Explained](https://datatoolspro.com/tutorials/understanding-snowflakes-newer-network-security-model-network-rules-policies-explained/) - Snowflake customers previously relied Network Policies to control access based on IP addresses. However, starting in 2024, Snowflake introduced Network Rules, a new approach to defining and managing network security. This shift brings greater flexibility, reusability, and improved security management. In this guide, we’ll break down the differences between the old and new approach, explain - [Create a GitHub personal access token for Snowflake and DataTools Pro](https://datatoolspro.com/tutorials/github-personal-access-token/) - To integrate GitHub source control with Snowflake or even DataTools Pro, you can create GitHub personal access token, which grants fine grained control. - [Create Salesforce Field Dictionary with DataTools Pro](https://datatoolspro.com/tutorials/salesforce-field-dictionary-with-datatools-pro/) - DataTools provides a Salesforce Field Dictionary that includes a detailed list of fields. - [Data Mapping Snowflake to Salesforce](https://datatoolspro.com/tutorials/data-mapping-snowflake-to-salesforce/) - Your meta data is now imported to use with DataTools migration and data mapping features - [Object Explorer for DataTools Pro Dictionary](https://datatoolspro.com/tutorials/object-explorer-for-datatools-pro-dictionary/) - DataTools Pro Dictionary provides Salesforce object exploration. By design, the object exploration is designed for fast access to the most important object views aligned to your business. - [Linking Salesforce Data Migration Scorecard to External Resources and Apps](https://datatoolspro.com/tutorials/linking-data-migration-scorecard-to-external-resources-and-apps/) - The Data Migration Object scorecard is designed to keep track of your Salesforce data migration project and can serve as a launchpad to link to supporting data assets - [How to Generate Snowflake Client ID and Secret for OAuth](https://datatoolspro.com/tutorials/how-to-generate-snowflake-client-id-and-secret-for-oauth/) - Acquire your Snowflake Account Account and org names in Snowflake can be tricky. The easiest and fastest way to acquire the correct account identifier is to: Login to Snowfake In the lower left corner, click on your profile icon to show settings Hover over your account to display the account, org, and locator screen. Clock - [Connect Azure DataFactory to Quickbooks](https://datatoolspro.com/tutorials/connect-azure-datafactory-to-quickbooks/) - To connect Azure Datafactory to QuickBooks you have to carve out at least 30 minutes to step through Intuit developer onboarding process which is less abbreviated than other developer processes. This is because they pool internal and third party development governance into 1 process. As such some of the steps may not seem logical, but - [Salesforce to Snowflake Data Type Mapping](https://datatoolspro.com/tutorials/salesforce-to-snowflake-data-type/) - Salesforce to Snowflake data type mapping is important to ensure you map the right data from Salesforce into the correct column data type. Common data types include INT for integers, VARCHAR for variable-length strings, DATE for dates, etc. When Snowflake loads data using the import from data option, it infers the data type of each - [Loading Salesforce CRM Analytics Dashboards in DataTools Pro](https://datatoolspro.com/tutorials/crm-analytics-dashboards-in-datatools-pro/) - DataTools Pro has added support for CRM Analytics Dashboards (CRMA) into DataTools Pro, alongside other reporting and dashboard assets. Currently CRM Analytics dashboards are the only assets accessed. Components and CRMA data sources are not currently loaded and referenced. - [Run Snowflake queries from GitHub](https://datatoolspro.com/tutorials/snowflake-queries-from-github/) - Running Snowflake queries from GitHub is possible with native Snowflake GitHub integration. To execute a query in Snowflake from Githhub directly, you can follow these steps: Step 1: Set Up GitHub Repository If you already have a GitHub repository with your SQL scripts, you can use it. Otherwise, create a new repository for your Snowflake-related - [Salesforce Entity Relationship Diagram Step by Step Guide](https://datatoolspro.com/tutorials/salesforce-erd-step-by-step-guide/) - This visual representation of the Salesforce ERD helps Salesforce, data, analytics, and business teams to understand the relational data model. - [Create ADF Data Pipeline Connecting Salesforce to Snowflake](https://datatoolspro.com/tutorials/create-adf-data-pipeline-connecting-salesforce-to-snowflake/) - create ADF data pipeline to connect Salesforce to Snowflake. This tutorial brings together all of the previous created data sets and connections to extract data out of Salesforce.com source and push it into a Snowflake table sink - [How to Resolve IP Restricted Error and Grant Access to Our App](https://datatoolspro.com/tutorials/how-to-resolve-ip-restricted-error-and-grant-access-to-our-app/) - We understand that you've encountered an "IP Restricted" error while trying to authenticate into our app using your Salesforce account. This occurs because your Salesforce profile has specific IP address restrictions. Here’s how you can resolve this issue: Why Does This Happen? Salesforce profiles can be configured to only allow login from specific IP addresses. - [Create Azure Data Factory Dataset Connected Salesforce](https://datatoolspro.com/tutorials/create-azure-data-factory-dataset-connected-salesforce/) - Connect to Salesforce Object with Azure ADF to create a dataset. Generating Datasets in Azure Data Factory is an block for building data pipelines. - [Snowflake Time Travel Practical Guide](https://datatoolspro.com/tutorials/snowflake-time-travel-practical-guide/) - Snowflake Time Travel is an amazing feature that allows you to query a historical snapshot up to 90 days in the past. - [Load Data from Snowflake GitHub Integration](https://datatoolspro.com/tutorials/snowflake-github-integration/) - Snowflake has a native integration with Github, allowing you to stage code and data. Using Github for source control adds another important governance function to Snowflake. We have create a step by step Snowflake GitHub integration setup tutorial. In this article, we will wexplore loading data, metadata, and executing code directly from Github. Loading data - [Snowflake Replication and Sharing Data Across Regions and Clouds](https://datatoolspro.com/tutorials/snowflake-replication-and-sharing-data-across-regions-and-clouds/) - Snowflake Replication is a powerful solution to seamlessly and securely replicate and share data across clouds (Azure, AWS, Google). - [Create a Snowflake System User to Load data into Data Factory](https://datatoolspro.com/tutorials/create-a-snowflake-system-user-to-load-data-into-data-factory/) - create a Snowflake system user to load data into Data Factory. This provides better security and control over data access. - [Snowflake to GitHub Repository: Step by Step Tutorial](https://datatoolspro.com/tutorials/snowflake-to-github/) - Snowflake to GitHub integration is another example how data and analytics professionals can use change management and source control with Snowflake - [Metrics Analyst for Salesforce Getting Started](https://datatoolspro.com/tutorials/getting-started-with-metrics-analyst-ai-for-salesforce/) - Getting Started with Metrics Glossary DataTools for Salesforce demonstrates how to build a dictionary for the most important metrics within your organization. - [Getting Started with Metrics Glossary DataTools for Salesforce](https://datatoolspro.com/tutorials/getting-started-with-metrics-glossary-datatools-for-salesforce/) - Metrics glossary DataTools serves as a dictionary for the most important metrics and KPIs within your organization. - [Salesforce Reports and Dashboards DataTools Overview](https://datatoolspro.com/tutorials/salesforce-reports-and-dashboards/) - Why does Salesforce Reports and Dashboards DataTools Exist?Filter PanelViewsAnalytics TypeLine of BusinessTopicDate Created FilterDate Last Modified FilterDate Last Viewed onStatusCreated byModified byManaging Dashboard and Report lifecycle with StatusTag Salesforce Reports and Dashboards by line of business and topicDataTools Pro refresh Salesforce analytics list Why does Salesforce Reports and Dashboards DataTools Exist? DataTools for Salesforce Reports - [DataTools Pro refresh Salesforce analytics list](https://datatoolspro.com/tutorials/refresh-salesforce-analytics/) - DataTools Pro will load and refresh Salesforce analytics list (reports and dashboards) so you can apply analyze the latest analytics in your organization. - [Manage Salesforce Dashboard Lifecycle with Status](https://datatoolspro.com/tutorials/manage-salesforce-dashboard-lifecycle-with-status/) - Update Status for Salesforce Dashboards and Reports 1. Click on a dashboard or report name to open the Info-Window 2. Select the Analytics Status Bulk Edit Status for Salesforce Dashboards and Reports DataTools Pro allows you to bulk select Dashboards and Reports so you can bulk update status. To complete this task: 1. Select the - [Tag Salesforce Reports and Dashboards by line of business and topic](https://datatoolspro.com/tutorials/tag-salesforce-reports/) - DataTools Pro free Salesforce app allows you to tag Salesforce Reports and Dashboards by line of business and topic. - [Segment Salesforce Report and Dashboard Views](https://datatoolspro.com/tutorials/salesforce-report-and-dashboard-views/) - We created DataTools Pro Salesforce report and dashboard views to help you quickly find the right dashboards and reports based on common management tasks. - [Schedule Salesforce object change tracking](https://datatoolspro.com/tutorials/schedule-salesforce-object-change-tracking/) - DataTools Pro provides Salesforce object change tracking that identifies when objects receive new fields or have fields deleted. This information is extremely important for downstream processes and integrations with your Salesforce organization. By default, changes are tracked only when a DataTools Pro user refreshes an object to look for changes. IMPORTANT NOTE: DataTools Pro does - [Export Salesforce Report to Excel: A Complete Guide](https://datatoolspro.com/tutorials/export-salesforce-report-to-excel/) - Learn the export Salesforce report to Excel feature and how to export a complete list of Salesforce reports to Excel. - [Data Tools Object and ERD Views](https://datatoolspro.com/tutorials/data-tools-erd-and-object-views/) - DataTools Object and ERD Views are designed to organize collections of Salesforce objects based on business semantics and topics - [Replacing Alteryx with Savant expressions](https://datatoolspro.com/tutorials/replacing-alteryx-with-savant-expressions/) - Replacing Alteryx with Savant has been a great experience so far, in particular when I have to obtain, transform and move files from many third party source. - [Add new user post invite process](https://datatoolspro.com/tutorials/add-new-user-post-invite-process/) - Post Invite, what happens next? When you invite a user they will receive an email with a one time password. When clicked it will open app.datatoolspro.com where they can authenticate with their Salesforce.com user. Until the user authenticates into your Salesforce org, they will remain in the invited user section Once an invited user has - [Import your metrics into Coda with DataTools Pro Bundle](https://datatoolspro.com/tutorials/import-metrics-into-coda-with-datatools-pro-c/) - Generate a DataTools Pro API Key for Coda Step 1: Access Coda settings page or click on the Coda icon on the Metrics Glossary page Step 2: Click "Create API Key" button Step 3: Save your API key to a secured location. DataTools Pro will display your API key only one time, and by design - [Export Metrics to Notion](https://datatoolspro.com/tutorials/export-metrics-to-notion/) - Export DataTools Pro metrics glossary to Notion with our direct API integration. - [DataTools ERD Toolbar Overview](https://datatoolspro.com/tutorials/datatools-erd-toolbar-overview/) - DataTools Pro ERDs features a series of tools to transform and export your Salesforce Entity Relationship diagrams. This article highlights all of the available options - [Using Snowflake Cortex LLM to Blend Data](https://datatoolspro.com/tutorials/using-snowflake-cortex-llm-to-blend-data/) - While at Snowflake annual conference in June, data experts congregated to share ideas, techniques and successes. One of the new innovations from Snowflake is Cortex. Creating an Embedding with Snowflake Cortex In this code example, I am taking our Salesforce leads table and chunking the data into a vector structure using SNOWFLAKE.CORTEX.EMBED_TEXT_768. More details on - [Managing DataTools Pro Subscription](https://datatoolspro.com/tutorials/managing-datatools-pro-subscription/) - DataTools Pro uses Stripe to handle all payments transactions, handling of credit cards and monthly / annual recuring subscriptions. Currently we are using Stripe's managed subscription functions. Access Stripe Subscription Console 1. Login to DataToolsPro. 2. View the Settings Page 3. Click on Billing & Subscription 4. Enter the email address used to purchase. For - [DataTools Pro Manage Account and Users](https://datatoolspro.com/tutorials/manage-datatools-pro-account-and-users/) - DataTools Pro provides standard roles and fine grained permissions to manage account and Users - [DataTools Pro API Documentation](https://datatoolspro.com/tutorials/datatools-pro-api-documentation/) - DataTools Pro API was built to extend and inject metrics data into your internal applications, AI agents, and data and analytics solutions - [Salesforce Analyst Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/getting-started-with-metrics-analyst-ai-for-salesforce-2/) - Getting Started with Metrics Glossary DataTools for Salesforce demonstrates how to build a dictionary for the most important metrics within your organization. - [Executive Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/executive-getting-started-guide-to-datatools-pro/) - Get started managing and analyzing your metadata with DataTools Pro - [Product Leader Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/product-leader-getting-started-guide-to-datatools-pro/) - Get started managing and analyzing your metadata with DataTools Pro - [Business Stakeholder Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/business-stakeholder-getting-started-guide-to-datatools-pro/) - Get started managing and analyzing your metadata with DataTools Pro - [Data Professional Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/data-professional-getting-started-guide-to-datatools-pro/) - Get started managing and analyzing your metadata with DataTools Pro - [Salesforce Developer Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/salesforce-admin-getting-started-guide-2/) - Get started managing and analyzing your metadata with DataTools Pro - [Salesforce Admin Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/salesforce-admin-getting-started-guide/) - Get started managing and analyzing your metadata with DataTools Pro - [Other Getting Started Guide to DataTools Pro](https://datatoolspro.com/tutorials/other-getting-started-guide-to-datatools-pro/) - Get started managing and analyzing your metadata with DataTools Pro - [Salesforce Object Access, Security and Troubleshooting in DataTools Pro](https://datatoolspro.com/tutorials/salesforce-object-access-in-datatools-pro/) - DataTools Pro uses the Salesforce REST API to access meta data within your organization. When you log into DataToolsPro as a user, it inherits and enforces the Salesforce security, role, and permissions settings anytime you request data from object browser dropdown. After an object is added you can naigate and view only fields that your - [Tableau Pulse Import to DataTools Pro Metrics Glossary](https://datatoolspro.com/tutorials/tableau-pulse-import-to-datatools-pro-metrics-glossary/) - Before you can import Tableau Pulse into DataTools Pro Metrics Glossary, you need to create a connection. Importing Metrics from Tableau Pulse Step 1. Navigate to the DataTools Pro Metrics tab Step 2. On the import bar click on the Tableau icon NOTE: For first time, use follow the directions to Link a Tableau personal - [Metrics Change History](https://datatoolspro.com/tutorials/metrics-change-history/) - DataTools metrics change history tool provides a detailed view of all historical changes to your metrics over time by user. Metrics naturally change over time with your business. Changes in metrics are typically not distributed across business, technology, data an analytics universally. How to Access Metrics History for All Metrics On the metrics tab, click - [Using a metrics alias for 1 metric with multiple names](https://datatoolspro.com/tutorials/metrics-alias/) - This tutorial covers using a metrics alias where you may have 1 unique metric or KPI that has an abbreviation or multiple names. - [Merging Metrics with DataTools Pro](https://datatoolspro.com/tutorials/merging-metrics/) - Merge your DataTools Pro metrics together for consolidated metrics management. - [Link Tableau Personal Access Token to DataTools Pro](https://datatoolspro.com/tutorials/link-tableau-personal-access-token-to-datatools-pro/) - Create a personal access token This procedure requires you to copy a secret to a file. The secret is the string that you will include in your automation scripts and will be used to authenticate to Tableau Cloud or Tableau Server. Handle the secret as you would a password: protect the secret and do not - [Migrate Data into Salesforce Video Series](https://datatoolspro.com/tutorials/migrate-data-into-salesforce-video-series/) - In this video series, we will walk through an end to end data migration from Zoho into Salesforce where we address some common data you may encounter. Step 1: Select and Staging Source Objects The first step in a data migration is inventory what objects and information we ae migrating out of the source system. - [Field History Tracking for Salesforce](https://datatoolspro.com/tutorials/field-history-tracking-for-salesforce/) - Our latest release of DataTools Pro introduces our new Field History Tracking for Salesforce. Currently, this new feature is focused only on updates made to fields. This is our first step to help DataTools users understand Salesforce field history tracking and changes that could impact downstream reporting and analytics. Using Salesforce Field History Tracking Tracking - [Linking Metrics and KPI Relationships](https://datatoolspro.com/tutorials/linking-metrics-and-kpi-relationships/) - Linking metrics allows you to capture and understand how metrics relate to each other and provides categorization that aligns to typical business cases. - [Migration Export SQL](https://datatoolspro.com/tutorials/migration-export-sql/) - Linking metrics allows you to capture and understand how metrics relate to each other and provides categorization that aligns to typical business cases. - [Salesforce Migration Field Mapping Details](https://datatoolspro.com/tutorials/salesforce-migration-field-mapping-details/) - The field migration mapping screen allows you to configure source object sand fields to map into Salesforce. - [Bulk Edit Multiple Metric Records](https://datatoolspro.com/tutorials/bulk-edit-multiple-metric-records/) - Bulk edit multiple metric records with DataTools Pro. This allows for streamlined experience and data management. - [Data Tools Access and Region Availability](https://datatoolspro.com/tutorials/data-tools-access-and-region-availability/) - DataTools Pro has been developed with global delivery in mind but we are running our initial beta close to home to ensure we thoughtfully roll out DataTools for Salesforce in alignment with Salesforce… - [Bulk Metric Import from Excel and CSV](https://datatoolspro.com/tutorials/bulk-metric-import-from-excel-and-csv/) - DataTools Pro provides a bulk import feature that translates any Excel or CSV file into the correct DataTools Pro format. - [Salesforce Free Data Cloud Setup Tutorial](https://datatoolspro.com/tutorials/salesforce-data-cloud-setup-tutorial/) - Salesforce Data Cloud setup tutorial provides Salesforce administrators with a starting point to to seamlessly integrating data from Salesforce and external sources - [Data Migration Scorecard for Salesforce](https://datatoolspro.com/tutorials/data-migration-scorecard-for-salesforce/) - The Data Migration Scorecard for Salesforce is designed to keep track of your Salesforce data migration project at the Salesforce object level. - [Mapping and Migrating Salesforce Picklists](https://datatoolspro.com/tutorials/mapping-and-migrating-salesforce-picklists/) - DataTools data migration picklist mapping allows you to map any number of inputs to a finite number of supported Salesforce picklist values - [Snowflake Zero Copy Sharing Example](https://datatoolspro.com/tutorials/what-is-snowflake-zero-copy-clone-and-sharing/) - Discover efficient data sharing with Snowflake's Zero-Copy Cloning. Create instant data clones without extra storage, enabling secure, real-time collaboration across teams or companies. - [Snowflake Direct Connector for Salesforce](https://datatoolspro.com/tutorials/snowflake-direct-connector-for-salesforce/) - Snowflake Connector for Salesforce pulls data into Salesforce for analysis and modeling out of the box. - [Snowflake Output Connector for Salesforcef](https://datatoolspro.com/tutorials/snowflake-output-connector-for-salesforce/) - Snowflake Output Connector for Salesforce eliminates the need for any data pipelines between Salesforce and your Snowflake database. - [Snowflake Input Connector for Salesforce](https://datatoolspro.com/tutorials/snowflake-input-connector-for-salesforce/) - Snowflake Input Connector for Salesforce allows you to import data on a scheduled batch or as live data. Access data from your Snowflake data warehouse in Salesforce. - [Use Salesforce DevTools Extension to Export Salesforce to Excel](https://datatoolspro.com/tutorials/use-dev-tools-extension/) - Exploring and share data from Snowflake with Datameer has never been easier with a point and click rapid no-code design. - [Complete Salesforce and Snowflake Data Manager Guide](https://datatoolspro.com/tutorials/complete-salesforce-snowflake-data-integration-guide/) - Snowflake Connectors in Salesforce Explained Make sure you check with your 3rd party app exchange partners that Tableau CRM is supported. There are a number of popular 3rd party app exchange apps that don't support Tableau Snowflake Connectors in Salesforce Explained 1. Snowflake Direct Connector 2. Snowflake Connector 3. Snowflake Output Connector 4. 3rd Party - [Datameer Column Profiling Snowflake Data](https://datatoolspro.com/tutorials/datameer-data-exploration-and-sharing-2-2/) - Datameer column profiling Snowflake data has never been easier thanks to native single click data profiling capabilities. - [Datameer Join Analysis with Snowflake Data](https://datatoolspro.com/tutorials/datameer-data-exploration-and-sharing-2/) - Datameer Join Analysis with Snowflake simplifies join profiling and analysis in seconds without any coding. - [Datameer Data Exploration and Sharing for Snowflake](https://datatoolspro.com/tutorials/datameer-data-exploration-and-sharing/) - Datameer data exploration and sharing for Snowflake provides the ability to analyze and understand your data without pulling any data out of Snowflake. - [Publish Azure Data Factory to GitHub](https://datatoolspro.com/tutorials/publish-azure-data-factory-to-github/) - Publish Azure data factory to GitHub, ensuring that assets like pipelines, datasets, and triggers are versioned and checked into source control. - [Create an ADF Scheduled Trigger](https://datatoolspro.com/tutorials/create-an-adf-scheduled-trigger/) - Create an ADF scheduled trigger that can automatically run your data pipelines at any interval (hourly, daily, weekly, monthly). - [Create Snowflake Table with Salesforce Leads Schema](https://datatoolspro.com/tutorials/create-snowflake-table-with-salesforce-leads-schema/) - Creating a Snowflake Table This tutorial you will use Snowflake to create a new system Leads table from Salesforce.com. In this case you can create your Salesforce table from Excel manually or pull the Table DDL out of Data Tools Pro Recent Articles about Snowflake - [Mask and Protect Sensitive Data with Snowflake Masking Policy](https://datatoolspro.com/tutorials/mask-and-protect-sensitive-data-with-snowflake-masking-policy/) - Snowflake provides a straightforward function that allows you to mask and obstruct sensitive data from roles in your organization. ## Upgrade Windows - [Reporting Zero Values - Line of Business](https://datatoolspro.com/upgrade_window/reporting-zero-values-line-of-business/) - The line of business you selected resulted in 0 records. You can view lines of business on the settings page. To learn more about lines of business and topics, please visit the help article. - [Reporting Zero Values- Status deprecated, in-progress](https://datatoolspro.com/upgrade_window/reporting-zero-values-status-2-2/) - The status you selected resulted in 0 records. You will need to set reports or dashboard status to filter records. - [Reporting Zero Values- Folder](https://datatoolspro.com/upgrade_window/reporting-zero-values-status-2/) - The folder you selected resulted in 0 records. You will need to set folder to filter records. - [Reporting Zero Values- Last Modified By](https://datatoolspro.com/upgrade_window/reporting-zero-values-last-modified-by/) - The selected filter you have chosen resulted in 0 records. This typically means the particular user has not modified reports or the combination of filters you have selected for reports and dashboards created by this user resulted in 0 records meeting your criteria. One recommendation to improve results is clearing your filters, selecting the "Created - [Reporting Zero Values- Created By](https://datatoolspro.com/upgrade_window/reporting-zero-values-created-by/) - The selected you have chosen resulted in 0 records. This typically means the particular user has not created reports or the combination of filters you have selected for reports and dashboards created by this user resulted in 0 records meeting your criteria. One recommendation to improve results is clearing your filters, selecting the "Created by" - [Reporting Zero Values- Views](https://datatoolspro.com/upgrade_window/reporting-zero-values-views/) - The selected view you have chosen resulted in 0 records. Some of the views provided by DataTools Pro first require using native features like Status to create more meaningful and useful views of your reports and dashboards. We have designed our views based on common administration tasks. To learn how to use and benefit from - [Reporting Zero Values- Last Viewed](https://datatoolspro.com/upgrade_window/reporting-zero-values-last-viewed/) - The last viewed date range you selected resulted in 0 records. Either none the reports and dashboards in your Salesforce organization have not been viewed in the in the specified timeframe, or you may not have refreshed your reports and dashboards in DataTools Pro. Learn more about refreshing reports and dashboards. - [Reporting Zero Values- Last Modified](https://datatoolspro.com/upgrade_window/reporting-zero-values-last-modified/) - The last modified date range you selected resulted in 0 records. Either the reports and dashboards in your Salesforce organization were not modified in the specified timeframe, or you may not have refreshed your reports and dashboards in DataTools Pro. Learn more about refreshing reports and dashboards. - [Reporting Zero Values- Date Created](https://datatoolspro.com/upgrade_window/reporting-zero-values-date-created/) - The status created date range you selected resulted in 0 records. Either the reports and dashboards in your Salesforce organization were not created in the specified timeframe, or you may not have refreshed your reports and dashboards in DataTools Pro. Learn more about refreshing reports and dashboards. - [Reporting Zero Values- Status](https://datatoolspro.com/upgrade_window/reporting-zero-values-status/) - The status you selected resulted in 0 records. You will need to set reports or dashboard status to filter records. To learn how to set Report and Dashboard status to help track the lifecycle of your reports. - [Reporting Zero Values - Topics](https://datatoolspro.com/upgrade_window/reporting-zero-values-topics/) - The topic you selected resulted in 0 records. You can view lines of business on the settings page. To learn more about lines of business and topics, please visit the help article. - [Upgrade and Add Users](https://datatoolspro.com/upgrade_window/upgrade-and-add-users/) - To add more users or upgrade your account from free to team licenses, simply add at least 1 user by clicking the add more users to visit our Stripe order management page. More information Managing DataTools Pro Subscription - [Branding](https://datatoolspro.com/upgrade_window/branding/) - We are offering 2 users at no charge to our early adopters to help share and spread usage and get feedback on our onboarding and permissions. If you need more users, we are offering early adopter pricing with full access to all features, excluding our API. Payments and subscription management is managed through the secured ## Courses - [Learn SQL for Salesforce](https://datatoolspro.com/courses/learn-sql-for-salesforce/) - Video Length: 3:06 Included 50+ Instructor-led videos tailored to your learning style Learn SQL Data Query Language (DQL) Guided Step-by-step tutorials with practical examples Over 65 questions to reinforce learning and test knowledge 12-month course access Weekly instructor office hour available to enrollees Access to new OpenAI Assistant SQL Course Tutor Receive a course certificate ## Lessons - [8.0 Final Lab - Full Funnel Facts](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/) - In this final lab, we are going to bring together many of the skills you have learned to build a full-funnel representation of your Salesforce organization, incorporating leads, accounts, and opportunities. In this full-funnel, you get to build a model of your leads and opportunities that you can slice and dice. We will continue to - [5.0 Joining Data](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/) - In SQL, a join is a way to combine rows from two or more tables based on a related column between them. It's used to pull together related data spread across multiple tables into a single query result. When you use reports or even custom report types, Salesforce is effectively performing joins to deliver data - [4.0 Exploring and Analyzing Data](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/) - At this point, we have a basic SELECT statement foundation so we can take the next step to explore a number of data analysis and aggregation clauses. We will explore each clause individually, comparing it to a Salesforce reporting counterpart. Missing from this list of clauses is JOIN, which we will explore in our next - [9.0 Expanding your learning](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/9-0-abstracting-and-reusing-queries-in-sql/) - Before we send you into the world to write SQL with a foundation, there are some important concepts to ensure you put your skills to efficient use! In this section we will highlight some common practices to help you write re-usable SQL and understand other SQL code samples that you will encounter from other developers. - [7.0 Working with Dates](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/) - At this stage in your learning, you have a well-rounded knowledge of SQL that simply requires more practice and repetition. From here forward, we will continue to practice and explore new functions to accomplish a variety of common data tasks. Let’s delve into the realm of date and date/time manipulation. In this lesson, we will - [6.0 Conditional Expressions](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/6-0-conditional-expressions/) - Conditional expressions can be likened to the tools you're familiar with in Salesforce, such as formula fields, validation rules, and workflow conditions. These SQL expressions enable you to implement logic directly within your database queries. This dynamic data manipulation is significantly more flexible in SQL and with Snowflake we will explore a fraction of the - [3.0 Loading and Data into Snowflake](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/) - In this lesson, we are going to move on from Hello World. Let’s move on to real-world scenarios where we will import data from Salesforce into your Snowflake database so we can query and explore sample data and prepare you to work with your own data. Today, most companies rely on third-party software to handle - [1.0 Introduction](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/1-0-introduction/) - Welcome to the “SQL for Salesforce” course! My name is Ryan Goodman, and I am happy to help provide some new tools and experience to help you along on your professional journey, and pass along the tricks and tools I have learned along the way. I provide my bio at the end of this lesson - [2.0 Hello World](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/2-0-hello-world/) - The following video introduces the Hello World lesson end to end. You can always come back to this video to reference and re-watch as you follow the step by step exercise. Hello World is the first lesson when starting any new programming language. The goal is to successfully use the programming language to output as ## Topics - [8.10 Create a Summarized Facts as Metrics](https://datatoolspro.com/topics/8-10-create-a-summary-of-your-facts/) - Our Last Task is to Create a Summary of our Metrics. We are going to treat your query as our . The structure of the query will be as follows SELECT FROM () Requirements for Metrics The following is a recap of the metrics dictionary requirements that we - [8.7 Joining Leads and Opportunities](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-7-joining-leads-and-opportunities8-7/) - Join on Lead ConvertedOpportunityId With our two queries defined, it’s time to figure out how we will bring them together via Join. We are going to explore a simpler query to explore our join options in a practical way. We want to join the Lead and Opportunity tables. To do so, we will first explore - [8.9 Pulling Leads and Opportunities into Your Joined Query](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-9/) - The queries from this lab have been re-organized logically before we combine them: LEADS QUERY SELECT L.Id, L.CreatedDate, L.ConvertedOpportunityId, L.ConvertedAccountId, L.Status, L.ConvertedDate, --CALCULATED FIELDS '1' as "Lead Count", CASE WHEN L.Status = 'Open - Not Contacted' then 0 ELSE 1 END "Qualified Leads" FROM SFDC.STAGE.LEAD L; OPPORTUNITY QUERY SELECT O.Id, O.CreatedDate, O.ExpectedRevenue, O.StageName, O.AccountId, O.CloseDate, - [8.8 Exploring Data and Understanding One to Many Relationships](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-8-one-to-many-relationships-1n/) - When you perform any join, understanding the entity-relationship and what you are measuring is extremely important. For example, when you join ConvertedAccountId from Lead to Account, 1 lead can be associated with multiple accounts. The way this can occur in practice is leads that are converted into existing accounts. This is a very reasonable use - [8.6 Opportunity Query](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-6-opportunity-query/) - With our Lead Query created, next, we will create an Opportunity query. Create a SELECT statement for SFDC.STAGE.OPPORTUNITY with a table alias of “O” and include the following fields: Id, CreatedDate, Revenue, Stage, AccountId, CloseWonDate If you find that the first attempt does not work perfectly, use the errors to help guide you along the - [8.5 Create New Lead Fields with Expressions](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-5-create-new-lead-fields-with-expressions/) - To produce some of the metrics in our glossary we will use conditional expressions we learned about in chapter 6. Lead Count Let’s create our first metric which takes us to our very first lab. If you wanted to represent the number ‘1’ for every record and call the field “Lead Count”, how would you - [8.1 Structuring your SQL](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-1-structuring-your-sql/) - this final lab, we are going to bring together many of the skills you have learned to build a full-funnel representation of your Salesforce organization, incorporating leads, accounts, and opportunities. In this full-funnel, you get to build a model of your leads and opportunities that you can slice and dice. We will continue to learn - [8.4 Create Lead Query](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-4-create-lead-query/) - Let’s put your SQL skills to work! Create a SELECT statement for SFDC.STAGE.LEAD with a table alias of “L” and include the following fields following fields: Id, CreatedDate, ConvertedOpportunityId,ConvertedAccountId,LeadStatus,ConvertedDate Tips on Troubleshooting If you find that the first attempt does not work perfectly, use the errors to help guide you along the way. Here are - [8.3 Understanding Salesforce Object Entity Relationships](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-3-understanding-salesforce-object-entity-relationships/) - Your Salesforce relational data model design is the foundation for your Salesforce application design and reporting. We didn’t dig into the details of relational modeling which is a foundational building block for SQL. I will share some amazing resources and books to dive deeper into these topics. Now that we are going to join and - [8.2 Final Lab Background](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-2-structuring-your-sql/) - In our final lab, we will walk through a framework that I use to gather requirements and determine the path forward. Using the same principles you utilize to requirements for your Salesforce org, we can ensure we write SQL code that properly addresses a real-world problem. Background A fairly common use case for reporting and - [8.11 Documentation and Delivery](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/topics/8-10-documentation-and-delivery/) - In any data analysis, data science, or data engineering project, clear and thorough documentation is as crucial as the technical execution itself. Proper documentation ensures that your SQL queries, data models, and analytical insights are accessible, understandable, and usable by others, including your future self. This section will cover the importance of documenting SQL queries - [7.5 LAST_DAY of Period](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/topics/7-5-last_day-of-period/) - Calculating the last day of a period, such as a month or a year, is a frequent requirement in data analysis, especially when dealing with financial, sales, or performance data that is often summarized on a monthly or annual basis. The LAST_DAY function simplifies this task by returning the date of the last day of - [7.4 Date Truncation](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/topics/7-4-date-truncation/) - Date Truncation is incredibly useful for aggregating, analyzing, and reporting data over specific time intervals, such as years, months, days, or even hours and minutes. By "truncating" a date, you essentially round it down to the nearest specified unit, which can simplify comparisons, aggregations, and trend analysis over periods of time. DATE_TRUNC( , ) - [7.2 Calculating Date Diffs ](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/topics/7-2-calculating-date-diffs/) - Snowflake simplifies the process of calculating the difference between dates and performing date arithmetic, such as adding or subtracting time intervals from specific dates. To calculate the difference between two dates, you can utilize the DATEDIFF function. The format of the function is as follows: DATEDIFF( , , ) An example and real-world use - [7.1 Converting from UTC](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/topics/7-1-converting-from-utc/) - In the realm of global data management, dealing with time zones is inevitable. Salesforce, for instance, stores all DateTime fields in UTC (Coordinated Universal Time) so it is time zone independent. This is incredibly useful to ensure data that is deployed to users reflects their local timezone when events occur. When you extract data into - [6.4 COALESCE](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/6-0-conditional-expressions/topics/6-4-coalesce/) - COALESCE returns the first non-NULL value from a list of expressions. It's like using a formula in Salesforce that checks multiple fields and returns the first field that has a value. This is particularly useful for data that might be spread across multiple fields, ensuring you get a result even if some fields are empty. - [6.3 IFF](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/6-0-conditional-expressions/topics/6-3-iff/) - IFF is a shorthand version of the CASE statement, available in some SQL dialects (like T-SQL and of course Snowflake). It's a straightforward way to write a conditional expression, similar to the "IF" function in Excel or Salesforce formulas. It evaluates a condition and returns one value if the condition is true and another if - [6.1 - CASE](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/6-0-conditional-expressions/topics/6-1-case/) - The CASE statement in SQL is like a series of "IF-THEN" statements in Salesforce formula fields. It lets you set conditions and outcomes within your query. For example, you might use CASE to categorize accounts based on their revenue, much like you might use a formula field to categorize leads in Salesforce. The good news - [5.2 JOIN Labs](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-2-join-labs/) - Lab Joining 2 Data Sources with a Left Join What if we wanted to return all leads with and without matched accounts? The following query with a LEFT JOIN will return all Leads that have and have not been converted to an Account. SELECT L."Name" as "LeadName", A."Name" as "AccountName" FROM LEAD AS L LEFT - [5.1 JOIN ON Condition](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-1-join-on-condition/) - To understand a join, let's first consider 2 queries: Table Alias When working with tables like Leads and Accounts, where both have columns named "Id" and "Name", aliasing becomes particularly useful to avoid ambiguity. For instance, in a SQL query involving a join between these two tables, you might encounter confusion if you just refer - [5.1.1 Characteristics of a Key](https://datatoolspro.com/topics/5-1-1-characteristics-of-a-key/) - When working with any relational database you have two methods to relate two tables. Primary Key: Uniquely identifies each row within a table. Salesforce for example as a business app, has a primary key on every field called "Id." Foreign Key: References a primary key in another table, establishing a relationship between tables. Is ConvertedAccountId - [7.3 Date Arithmetic with DateAdd](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/topics/7-3-date-arithmetic-with-dateadd/) - Adding or subtracting time intervals to dates is straightforward with the DATEADD function. The following is the format for the DATEADD function. DATEADD( , , ) The “Date or Time Part” can be any of the date time parts supported by Snowflake: year month day week quarter hour minute second Millisecond For example, to - [4.2.1 Grouping and Summarizing](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-2-1-grouping-and-summarizing/) - In SQL, the GROUP BY clause and aggregate functions are fundamental tools for organizing and summarizing data. Understanding these concepts allows you to extract meaningful insights from your data sets. GROUP BY Clause: The GROUP BY clause in SQL is used to group rows that have the same values in specified columns into summary rows. - [4.4.1 Filtering Groups with HAVING Clause](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-4-filtering-groups-with-having-clause/) - In previous lessons, you learned about the WHERE clause, which allows you to filter individual records in your data. You also learned about aggregating and summarizing data using GROUP BY. What if you want to filter your data after it has been aggregated? What does HAVING do? The HAVING clause in SQL is used to - [4.3.1 Sorting Data with ORDER BY](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-3-sorting-data-with-order-by/) - As a recap, we have walked through clauses in a SQL SELECT statement in order to lead us up to this point where we are now ready to sort data. The ORDER BY clause in SQL is important for sorting the results of a query in either ascending or descending order. It enhances the readability - [4.2.3 Translating Requirements to Code](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-2-3-translating-requirements-to-code/) - Clarity on Translating Requirements to Code This is where we pause for a minute on a step by step coding and take a step back to focus on an important practical application of what we are learning. Gathering requirements for SQL is similar to Salesforce where you need clear definitions and intent. It may require - [4.2.2 Aggregate Functions](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-2-2-aggregate-functions/) - Aggregate functions perform a calculation on a set of values and return a single value. Common aggregate functions include: COUNT(): Counts the number of rows in each group. SUM(): Adds up the values in a specific column for each group. AVG(): Calculates the average of values in a specific column for each group. MAX() and - [4.1.4 BETWEEN Filter Expression](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-1-4-between-filter-expression/) - BETWEEN Filter Expression The BETWEEN condition in SQL allows you to filter data within a specific range, and NOT BETWEEN excludes a range. This is similar to setting range criteria in Salesforce report filters, where you might want to see records created within a certain timeframe. Salesforce reporting provides the equivalent in the form of - [4.1.1 Filtering Data with Conditions](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-1-1-filtering-data-with-conditions/) - In this topic, we will learn how to apply the same knowledge and experience filtering data in Salesforce reports to implement a WHERE clause in SQL to constrain data to a smaller subset. Within Salesforce reports you have filter operators that can be applied to text and operators that can be applied to values. Filter - [4.1.3 Setting an Expression to Compare Two Fields](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-1-3-setting-an-expression-to-compare-two-fields/) - Expressions with Multiple Conditions To this point, we have constructed a WHERE clause with a single condition that is being evaluated to filter the resulting data. A condition is a type of expression that is often used in a WHERE clause. In simple terms, an expression is a phrase in SQL that can be evaluated - [3.5 Create your Own Select Statement Lab](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/topics/3-5-create-your-own-select-statement-lab/) - Select Individual Columns To select individual columns, you can type the names of the columns wrapped in double quotes. It is important to note that databases vary in their syntax for selecting field names. Snowflake in particular requires double quotes when column names are case-sensitive or have spaces. For the purpose of our training, I - [3.4 Querying Lead Data Lab](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/topics/3-4-querying-lead-data-lab/) - Create your Own Select Statement to Query Lead Data Let’s build upon what we already learned in Lab 1 and review the following SELECT statement: SELECT * FROM LEAD; Select All Columns To select all columns in your table, you will enter the asterisk symbol “*” to signal that you would like all columns returned - [3.3 Loading Data into Snowflake Lab](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/topics/3-3-loading-data-into-snowflake-lab/) - Lab 2 – Loading Data into Snowflake In this second lab, we are going to borrow from the ELT concept I explained to load and stage data into Snowflake without any data transformations. This will pre-load all of the data we need to complete the rest of our labs and provide familiarity with some common - [3.2 Salesforce / Snowflake Integrations](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/topics/3-2-salesforce-snowflake-integrations/) - Salesforce / Snowflake Integrations With recent advancements in Salesforce CRM Analytics and Data Cloud, we have Salesforce native data pipelines into Snowflake. I have covered this topic extensively for Salesforce Ben having written two articles that highlight the latest methods for Salesforce native Snowflake connectivity. The skills you are learning in these labs will allow - [3.1 Loading Data from Salesforce into Snowflake](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/topics/3-1-loading-data-from-salesforce-into-snowflake/) - Loading Data from Salesforce into your Database In the world of business applications and data cloud platforms there is seemingly an unlimited number of approaches to work with data. The trick I have found to remain objective is to stay razor focused on outcomes and results, not the mechanics and technology tools. Considering we are - [9.3 Concluding your Learning](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/9-0-abstracting-and-reusing-queries-in-sql/topics/9-3-concluding-your-learning/) - We have concluded the hands-on learning for introduction to SQL. We covered a lot of ground to give you a strong foundation to build from. There are several intermediate to advanced topics that you can explore on your own: Additional Reading and Traditional Reading and Learning Paths This course was purposefully built for the Salesforce - [9.2 Best Practices](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/9-0-abstracting-and-reusing-queries-in-sql/topics/9-2-best-practices/) - Nested Queries: Use for small, intermediate calculations or filters. CTEs: Use for breaking down complex queries into manageable parts, especially when the same subquery logic is needed multiple times within the query. Derived Tables: Use for creating temporary tables within a query for intermediate results, particularly useful when the derived results are only needed for - [9.1 Abstracting and Reusing Queries in SQL](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/9-0-abstracting-and-reusing-queries-in-sql/topics/9-1-abstracting-and-reusing-queries-in-sql/) - Nested Queries (Subqueries) A nested query, or subquery, is a query within another query. We explored our first sub-query as extra credit in our union. can be used to perform intermediate calculations or to filter results based on complex criteria. There are a couple kinds of sub-queries: Inline Subqueries These subqueries are used in the - [7.6 Integrating Conditional Logic with Date Functions](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/topics/7-6-integrating-conditional-logic-with-date-functions/) - Snowflake's SQL capabilities allow you to combine conditional expressions with date functions for more complex data manipulation. For example, you can determine the next renewal date based on the opportunity stage: CASE WHEN "StageName" = 'Closed Won' THEN DATEADD('years', 1, "CloseDate") ELSE NULL END AS "Next Renewal Date" In this case, if the opportunity stage - [6.5 Working with NULL Values](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/6-0-conditional-expressions/topics/6-5-working-with-null-values/) - Now that we are exploring the world of expressions, we know from experience that data by nature is imperfect. Your Salesforce org contains many fields missing data for a multitude of reasons. Without going deep into the details of how a database works, know that there are scenarios where you have to account for NULL - [6.2 Real-world Salesforce Formula vs SQL – Where Should Logic Reside?](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/6-0-conditional-expressions/topics/6-2-real-world-salesforce-formula-vs-sql-where-should-logic-reside/) - We just explored a function that could be implemented inside of Salesforce. So, if you are wondering why we wouldn’t simply implement this kind of CASE statement inside of Salesforce, your line of thinking is correct. Several considerations determine when and where to apply logic as you explore the world of SQL and Snowflake. Use - [5.4 Normalized vs Denormalized Data](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-4-normalized-vs-denormalized-data/) - Understanding Normalized vs Denormalized Data While working in Salesforce, you are working within a relational data model that is “normalized”. When you join these tables together you could be denormalizing your data which helps for data analysis but without care can change the meaning of your data by introducing what would be perceived as “duplicate” - [5.3 Profiling & Analyzing Joined Data](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-3-profiling-analyzing-joined-data/) - Now that you have joined two tables together, there is some profiling, analysis, and critical thinking required to ensure your result will accurately reflect your desired output. There are numerous issues that can arise where your results will mis-represent your desired results. In theory, you wanted to understand Leads that are converted. An inner join - [5.5 Combining two data sources with UNION](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-5-combining-two-data-sources-with-union/) - In SQL, a UNION is used to combine and stack the result sets of two or more SELECT queries. When you create a union, each SELECT query must have the same number of columns in the result sets with similar data types. This operation allows you to stack and consolidate data from different queries into - [5.6 Enhancing UNION Results](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-6-enhancing-union-results/) - Labeling each query results with a Constant When you use a union to combine two query results, you lose context where each query originated. Additionally if you want to use this data result to pivot and analyze data this context is very important. Let’s enhance each query with a “SEGMENT” constant. We learned about adding - [5.7 Extra Credit - Putting Union Data to Work](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-7-extra-credit-putting-union-data-to-work/) - To this point, we have been writing code and viewing results. To explain the value of the data set you just created, I have exported the data and pulled into Excel to pivot and aggregate the data. As you can see, in 1 data set we can view two independent activities together in a funnel. - [4.1.2 Standard Logical Operators](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-1-2-standard-logical-operators/) - Filter by Value We will continue our lab in the same worksheet adding additional queries. Let’s explore a WHERE clause to see how many leads have more than three locations using the field “NUMBEROFLOCATIONS__C”. How do you think we would represent this SQL? Try within your existing workbook to code the SQL for the requirement. - [2.1 Hello World Lab](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/2-0-hello-world/topics/2-1-hello-world-lab/) - Hello World is the first lesson when starting any new programming language. The goal is to successfully use the programming language to output as a result. This demonstrates that you have the ability to input code and retrieve output. SQL, or Structured Query Language, is a powerful tool for managing and querying data in databases. - [2.2 Basic SQL Statements - DQL](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/2-0-hello-world/topics/2-2-basic-sql-statements-dql/) - Basics SQL Statement Now, we will dig into the components of a SELECT statement so you understand the building blocks of the code you just ran and how we will build upon Hello World to start querying our database. SELECT Most of the SQL you will learn early on starts with a command that instructs - [1.1 Why SQL Proficiency Matters in the Salesforce Ecosystem](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/1-0-introduction/topics/1-1-why-sql-proficiency-matters-in-the-salesforce-ecosystem/) - Salesforce has been investing heavily in Data Cloud, meaning more customer-related data will flow in and out of Salesforce. Having a background and understanding of how those processes work with an SQL foundation will help you understand the needs and requirements of your data team. Salesforce’s “Bring your own Datalake” BYOL will allow external data - [1.3 Expectations and Outcomes](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/1-0-introduction/topics/1-3-expectations-and-outcomes/) - This course will focus on Data Query Language, DQL for short. The aim of introducing SQL is to focus on query and analysis use cases for selecting data from your database. This is a great starting point and gives you coverage and common ground when collaborating with analytics and data teams. We will leverage Snowflake - [1.2 Marketability of SQL in your Skills Arsenal](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/1-0-introduction/topics/1-2-marketability-of-sql-in-your-skills-arsenal/) - Employees with SQL skills earn an average of 10% more than those without, according to PayScale.com. The job market for SQL skills is projected to grow 10% between 2020 and 2030, much faster than the average for all occupations. (Source: Bureau of Labor Statistics) 72% of hiring managers in the United States consider SQL skills - [1.4 Instructor Bio](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/1-0-introduction/topics/1-4-instructor-bio/) - Below is my official bio, but more importantly my social links to connect directly with me. I want to hear about your experience, background and how we can make this course the best it can be to help you along your journey. Don't hesitate to reach at any point. Formal Bio Ryan brings over 20 - [1.5 Developer Org Setup](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/1-0-introduction/topics/1-1-developer-org-setup/) - To successfully complete this course you will need access to a Snowflake trial and preferably a Salesforce org with an administrator role to follow along. We will not perform any changes, data insertion, or extraction from Salesforce. Instead, I will provide sample data pre-extracted from a Salesforce trial org that we will load into Snowflake - [2.4 Debugging with AI](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/2-0-hello-world/topics/2-4-debugging-with-ai/) - Since 2023, and we live in a world where AI chatbots can serve as SQL co-pilots and QA checkers!. In this lab, I copy pasted code that was invalid because of the double quote formatting. To debug this in ChatGPT, you can copy and paste your SQL and then copy/paste the error. I have included - [2.3 Anatomy of a Database](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/2-0-hello-world/topics/2-3-anatomy-of-a-database/) - Now that you have written your first SQL statement we are going to take one step back before we charge forward to understand the anatomy of a relational database. The information you learn here is universal to any modern database. Without getting into the detailed nuances and technology architecture of Snowflake and a Relational Database - [9.1 Concluding your Learning](https://datatoolspro.com/topics/9-1-concluding-your-learning/) - We have concluded the hands-on learning for introduction to SQL. We covered a lot of ground to give you a strong foundation to build from. There are several intermediate to advanced topics that you can explore on your own: Additional Reading and Traditional Reading and Learning Paths This course was purposefully built for the Salesforce - [5.1 Combining Queries into a Union](https://datatoolspro.com/topics/5-1-combining-queries-into-a-union/) - [4.1 Filtering Data with Conditions](https://datatoolspro.com/topics/4-1-filtering-data-with-conditions/) - In this topic, we will learn how to apply the same knowledge and experience filtering data in Salesforce reports to implement a WHERE clause in SQL to constrain data to a smaller subset. Within Salesforce reports you have filter operators that can be applied to text and operators that can be applied to values. Filter ## Quizzes - [3.2 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/topics/3-5-create-your-own-select-statement-lab/quizzes/review-3/) - [3.1 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/3-0-loading-and-data-into-snowflake/topics/3-4-querying-lead-data-lab/quizzes/3-1-review/) - [7.0 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/7-0-working-with-dates/quizzes/7-0-review/) - [5.2 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-7-extra-credit-putting-union-data-to-work/quizzes/5-2-review/) - [2.3 Quiz - SQL DB Anatomy Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/2-0-hello-world/topics/2-3-anatomy-of-a-database/quizzes/2-3-quiz-sql-db-anatomy-review/) - [2.2 Quiz- Review Basic DQL](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/2-0-hello-world/topics/2-2-basic-sql-statements-dql/quizzes/2-0-review/) - Congratulations on your second completed module! Now you are going to take your first quiz so we can test your knowledge and retention of the content. - [5.1 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/5-0-joining-data/topics/5-4-normalized-vs-denormalized-data/quizzes/5-1-review/) - [8.0 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/8-0-final-lab/quizzes/8-0-review/) - [6.0 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/6-0-conditional-expressions/quizzes/6-0-review/) - [4.4 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-4-filtering-groups-with-having-clause/quizzes/4-4-review/) - [4.3 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-3-sorting-data-with-order-by/quizzes/4-3-review/) - [4.2 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-2-3-translating-requirements-to-code/quizzes/4-2-review/) - [4.1 Review](https://datatoolspro.com/courses/learn-sql-for-salesforce/lessons/4-0-exploring-and-analyzing-data-in-a-single-table/topics/4-1-4-between-filter-expression/quizzes/4-1-review/) ## Lessons - [Building Metrics Glossary for Salesforce with DataTools Pro](https://datatoolspro.com/lesson/metrics-glossary-for-salesforce/) - This short tutorial shows you how to build a Metrics Glossary for Salesforce with DataTools Pro. - [Getting Started with DataTools ERDs for Salesforce](https://datatoolspro.com/lesson/datatools-erds-for-salesforce/) - Build DataTools ERDs for Salesforce for free. This video lessons provides step by step instructions how. - [Create a Salesforce data dictionary](https://datatoolspro.com/lesson/salesforce-data-dictionary/) - This getting started tutorial shows you how to connect and create a Salesforce data dictionary within DataTools Pro. - [Welcome to DataTools Pro](https://datatoolspro.com/lesson/welcome-to-datatools-pro/) - Welcome to DataTools Pro! This video welcomes you to using the DataTools Pro app. ## Categories - [Uncategorized](https://datatoolspro.com/category/uncategorized/) - [Data Visualization and Dashboards](https://datatoolspro.com/category/data-visualization-and-dashboards/) - [Snowflake](https://datatoolspro.com/category/snowflake/) - [Salesforce](https://datatoolspro.com/category/salesforce/) - Salesforce tools for improved data and meta data analysis - [Data Migration](https://datatoolspro.com/category/migration/) - [Salesforce Data Migration](https://datatoolspro.com/category/sfdcmigration/) - [Datameer](https://datatoolspro.com/category/datameer/) - Datameer content Datameer data preparation and analysis for Snowflake - [Analytics](https://datatoolspro.com/category/analytics/) - [Artificial Intelligence](https://datatoolspro.com/category/ai/) - [OpenAI](https://datatoolspro.com/category/ai/openai/) - [Azure ADF](https://datatoolspro.com/category/azureadf/) - [Webinar](https://datatoolspro.com/category/webinar/) - [DataTools Pro](https://datatoolspro.com/category/datatoolspro/) - Data Tools Pro - [Data Cloud](https://datatoolspro.com/category/data-cloud/) - [Marketing Cloud](https://datatoolspro.com/category/data-cloud/marketing-cloud/) - [Tableau](https://datatoolspro.com/category/tableau/) - [Azure CoPilot](https://datatoolspro.com/category/azure-copilot/) - [Savant](https://datatoolspro.com/category/savant/) - [Zapier](https://datatoolspro.com/category/zapier/) - [AgentForce](https://datatoolspro.com/category/ai/agentforce/) - [SOQL](https://datatoolspro.com/category/soql/) - [Hubspot](https://datatoolspro.com/category/hubspot/) - [Marketing Analytics](https://datatoolspro.com/category/marketing-analytics/) - [Alteryx](https://datatoolspro.com/category/alteryx/) - [Semantics](https://datatoolspro.com/category/semantics/) - [DataTools Pro Explorer](https://datatoolspro.com/category/datatools-pro-explorer/) - [Power BI](https://datatoolspro.com/category/analytics/power-bi/) - [Claude](https://datatoolspro.com/category/ai/claude/) ## Courses - [DataTools Pro 101](https://datatoolspro.com/course/dtp/) ## Topic Categories - [SQL for Salesforce](https://datatoolspro.com/topic-category/sql-for-salesforce/) ## Topic Tags - [Hello World](https://datatoolspro.com/topic-tag/hello-world/) - [Introduction](https://datatoolspro.com/topic-tag/introduction/) - [Lab](https://datatoolspro.com/topic-tag/lab/) - [Loading and Viewing Data](https://datatoolspro.com/topic-tag/loading-and-viewing-data/) - [Group By](https://datatoolspro.com/topic-tag/group-by/) - [Aggregation](https://datatoolspro.com/topic-tag/aggregation/) - [Project Management](https://datatoolspro.com/topic-tag/project-management/) - [Order by](https://datatoolspro.com/topic-tag/order-by/) - [join](https://datatoolspro.com/topic-tag/join/) - [CASE](https://datatoolspro.com/topic-tag/case/) - [IFF](https://datatoolspro.com/topic-tag/iff/) - [expressions](https://datatoolspro.com/topic-tag/expressions/) - [COALESCE](https://datatoolspro.com/topic-tag/coalesce/) - [CONVERT_TIMEZONE](https://datatoolspro.com/topic-tag/convert_timezone/) - [DATEDIFF](https://datatoolspro.com/topic-tag/datediff/) - [DateAdd](https://datatoolspro.com/topic-tag/dateadd/) - [date_trunc](https://datatoolspro.com/topic-tag/date_trunc/) - [expression](https://datatoolspro.com/topic-tag/expression/) - [last_day](https://datatoolspro.com/topic-tag/last_day/) - [key](https://datatoolspro.com/topic-tag/key/)