Top "Snowflake-cloud-data-platform" questions

Snowflake Cloud Data Platform has a multi-cluster, shared architecture that provides a single location for structured and semi-structured data that can be queried using ANSI SQL.

Split a large json file into multiple smaller files

I have a large JSON file, about 5 million records and a file size of about 32GB, that I need to …

python json node.js lambda snowflake-cloud-data-platform
Snowflake: "SQL compilation error:... is not a valid group by expression"

Without resorting to CTEs or a sub-query is there any way to use Window functionality with a different summary level …

sql count sum snowflake-cloud-data-platform window-functions
SELECT INTO syntax for Snowflake Datawarehouse

I believe there's an SELECT INTO-like syntax in Snowflake, but I am unable to find documentation or examples to use …

sql insert-into snowflake-cloud-data-platform
Query to Snowflake database isn't working because no active warehouse is selected

I'm able to successfully connect to the Snowflake database via R but I'm having trouble getting the data because no …

python r snowflake-cloud-data-platform
NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:snowflake

I've installed all the necessary packages: pip install --upgrade snowflake-sqlalchemy I am running this test code from the snowflake docs: …

python sqlalchemy snowflake-cloud-data-platform
Adding row IDs to table in Snowflake SQL

I need to add a column with unique integers/hashes to a table to serve as the row id. I …

sql snowflake-schema snowflake-cloud-data-platform
How can I populate a pandas DataFrame with the result of a Snowflake sql query?

Using the Python Connector I can query Snowflake: import snowflake.connector # Gets the version ctx = snowflake.connector.connect( user=USER, …

pandas dataframe snowflake-cloud-data-platform
How to export data to local system from snowflake cloud data warehouse?

I am using snowflake cloud datawarehouse, which is like teradata that hosts data. I am able run queries and get …

database cloud snowflake-cloud-data-platform