Collect Snowflake data into your data warehouse or ours. The Matatika pipelines will take care of the data collection and preparation for your analytics and BI tools.
Snowflake is a cloud-based data warehousing platform.
Snowflake is a fully-managed service that allows businesses to store, process, and analyze large amounts of structured and semi-structured data using cloud-based infrastructure. It provides a scalable and secure solution for data warehousing, data lakes, data engineering, data science, and data sharing. Snowflake's unique architecture separates compute and storage, allowing users to scale each independently and pay only for what they use. It also offers features such as automatic scaling, zero-copy cloning, and instant elasticity, making it easy for businesses to manage their data and derive insights from it. With Snowflake, users can query data using SQL, integrate with popular BI and ETL tools, and collaborate with others through secure data sharing.
To obtain the required settings for connecting to Snowflake, you will need to have access to a Snowflake account. Once you have access, you can obtain the following settings:
The name or URL of the Snowflake account to connect to.
The name of the Snowflake database to connect to.
The username to use when connecting to Snowflake.
The password to use when connecting to Snowflake.
The name of the Snowflake warehouse to use for the connection.
The list of tables to include in the connection.
The Snowflake role to use for the connection.
The default replication method to use for the connection.
The path to the private key file to use for the connection.
The passphrase to use for the private key file.
Whether to allow insecure connections to Snowflake.
Extract, Transform, and Load Snowflake data into your data warehouse or ours.