Connectors, dbt & BI Tools

Snowflake · Ecosystem & Integrations

Theory

Snowflake sits at the centre of a typical modern data stack. Ingestion tools such as Fivetran or Airbyte, the Kafka connector and Snowpipe bring data into raw schemas. Transformation tools such as dbt turn raw tables into clean models: each dbt model is a SELECT, ref() declares dependencies, and dbt runs them in order as tables or views inside Snowflake, with tests and documentation. BI tools like Tableau, Power BI and Sigma then query the curated layer.

Applications connect through official drivers and connectors, including the Python connector, JDBC, ODBC, Node.js, Go, .NET and the Spark connector. All of them use the same accounts, roles and warehouses, so security and cost controls apply no matter which tool sends the query.

Why we use it

No single tool does everything. Knowing how connectors, ingestion, transformation and BI tools fit around Snowflake lets you design a stack where each tool does its job and data stays in one governed place.

When to use it

Use managed ingestion tools for SaaS sources, Snowpipe or the Kafka connector for files and streams, dbt for SQL transformations with testing and lineage, and give each tool its own service user, role and warehouse.

Drivers & Connectors

Official connectors exist for Python, JDBC, ODBC, and Spark, letting any application or notebook query Snowflake the same way it would any other SQL database, using standard connection strings and credentials.

dbt (data build tool)

dbt is the most common transformation layer on top of Snowflake — it compiles version-controlled SQL models into views/tables and manages the dependency order between them, complementing (not replacing) native Tasks and Dynamic Tables.

BI Tools & ELT Pipelines

Tableau, Power BI, and Looker connect natively via ODBC/JDBC for dashboards, while ELT tools like Fivetran and Airbyte handle pulling data from SaaS sources into Snowflake, and the Kafka connector streams event data in continuously.

How it works

  1. Source systems: apps, SaaS, files, events
  2. Ingestion tool or Snowpipe loads raw data
  3. dbt builds staging and curated models with ref()
  4. Do dbt tests pass? Yes: Publish curated models to BI. No: Fix the data or model and rerun.
  5. BI tools query curated tables through drivers

Example

-- Example dbt model (models/customer_ltv.sql)
SELECT customer_id, SUM(amount) AS lifetime_value
FROM {{ ref('orders') }}
GROUP BY customer_id;

Key points

Snowflake topics

Snowflake Fundamentals

Warehouses & Performance

Staging & SnowSQL

Tables & Data Handling

Cloud Integrations

Storage & Optimization

Security & Governance

Views, Pipelines & Automation

Data Types & SQL Fundamentals

Semi-Structured Data Deep Dive

Advanced Features

Data Sharing & Collaboration

Cost Management & Monitoring

Databases, Schemas & Objects

Performance Deep Dive

Advanced Security & Governance

Stored Procedures & UDFs

Ecosystem & Integrations

SnowPro Certification Prep

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Mastering Snowflake

The modern data cloud, from architecture to SnowPro certification. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice Snowflake SQL Sharpen the SQL you use in Snowflake: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Snowflake  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Unlike the SQL and Python courses, Snowflake needs a real account — there's no in-browser engine for it. Click Copy above, then paste it into a free Snowflake trial (30 days, no card required) and run it in Snowsight.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic