Snowflake
Your Snowflake data turned into API Endpoints in minutes
Working with Tinybird is easy. Ingest data from Snowflake. Write SQL. Publish API endpoints in a click. Results are always up to date and fast as can be.
Trusted by companies like...
Quick setup
Connect to Snowflake using your Snowflake account details and Google account, project and bucket details, to start building APIs right away.
Just use SQL
Use SQL to get the data from Snowflake, and then transform that data with SQL in Tinybird.
Automated & documented
Turn your query results into APIs in a click, automatically documented and ready to scale in production.
Completely secure
Use Auth tokens to control access to API endpoints. Implement flexible access policies with row-level security.
Build things with data in minutes, not weeks
Ingest, query, and build APIs on your Snowflake data in a matter of minutes. Forget about ETL, infrastructure scale, and complex security rules.
$ tb \
datasource append $DESTINATION_DATA_SOURCE \
--connector snowflake \
--sql "select * from $TABLE"
** 🐔 starting export process from snowflake
** 🥚 starting import process
** 🐥 done
** Total rows in taxi: 232341
** Data appended to data source 'taxi' successfully!
** Data pushed to taxi
NODE avg_triptime_endpoint
SQL >
SELECT
toDayOfMonth(pickup_datetime) as day,
avg (dateDiff('minute', pickup_datetime, dropoff_datetime)) as avg_trip_time_minutes
FROM tripdata
{% if defined(start_date) and defined(end_date) %}
WHERE pickup_dt BETWEEN {{Date(start_date)}} AND {{Date(end_date)}}
{% end %}
GROUP BY day
$ tb push endpoints/avg_triptime.pipe
** Processing endpoints/avg_triptime.pipe
** Building dependencies
** Running avg_triptime
** => Test endpoint at https://api.tinybird.co/v0/pipes/avg_triptime.json
** 'avg_triptime' created
** Not pushing fixtures
Automate ingestion of data from your Snowflake database.
Filter, clean or enrich your data using Pipes, a new way of chaining SQL queries designed to ease development and maintenance.
Share access securely to your data in a click and get full OpenAPI and Postman documentation for your APIs.
We accelerate your data, no matter where it is.
Connect data from Relational Databases, Data Warehouses and Data Streams.
Amazon Redshift
Amazon S3
Google BigQuery
Apache Kafka
PostgreSQL
MySQL
Snowflake
