Snowflake - ERROR [HY000] [Snowflake][Snowflake] (4)

ERROR [HY000] [Snowflake][Snowflake] (4) We are running ODBC on a Windows 10 computer. I have posted an image of the error messages below. We are also NOT using a proxy server. enter image...

sqitch init snowflake cannot determine Snowflake account name

I'm following the sqitchtutorial-snowflake tutorial and getting stuck when initializing a sqitch project When i run sqitch init widgets --engine snowflake The terminal indicates, "Cannot determine...

Snowflake EXPLAIN query support with Snowflake JDBC Driver

Is there a way to run an EXPLAIN snowflake query through the JDBC driver with the Snowflake extension? I am running net.snowflake snowflake-jdbc 3.12.8 and it throws an error saying...

snowflake Python Connection KeyError: 'snowflake-connector-python

I have installed snowflake sqlachemy package. and successfully developed the script to upload a csv file to snowflake. But when I upload the script to aws glue and supply the wheel file, I...

Connection from Spark to snowflake

I am writing this not for asking the question, but sharing the knowledge. I was using Spark to connect to snowflake. But I could not access snowflake. It seemed like there was something wrong with...

Does Snowflake support indexes?

In the Snowflake documentation, I could not find a reference to using Indexes. Does Snowflake support Indexes and, if not, what is the alternative approach to performance tuning when using Snowflake?

mocking snowflake connection

I have a SnowflakeApi class in python which just works as a wrapper on top of the SnowflakeConnection class. My SnowflakeApi is import logging import os from snowflake.connector import...

Power BI + Snowflake SSO

Snowflake PowerBI Is it possible to use different warehouse in snowflake for data refresh in Power BI than warehouse used for dashboard development? I'd like to have separate warehouse for data...

Snowflake - how to connect to Snowflake using NodeJS

Does anyone has a working code to connect NodeJS and Snowflake. Tried following instructions for NodeJS: var snowflake = require('snowflake-sdk'); var connection =...

Connection from Databricks to Snowflake

Using Databricks notebook, I am able to connect to 'snowflake' from Databricks and write content to a table in Snowflake using 'scala' but it doesn't work using 'python'. I have added both...

Snowflake Pandas connection issue

I'm trying to insert a dataframe into a snowflake table using the pandas connector and am getting permission issues, but using the "normal" snowflake connector works fine. ``` import...

Installing Snowflake JDBC driver

I am trying to install Snowflake JDBC driver according to instructions. I have downloaded and installed Java from here, then downloaded snowflake-jdbc-3.6.9.jar file from here. When I...

pass snowflake connection parameters in snowflake operator in airflow

We are using AWS-managed apache airflow 2.0.2. I am passing the snowflake schema name through dag run config. I am able to use this schema name in the python operator but not in the snowflake...

Using apache-airflow-providers-snowflake on airflow (no module named Snowflake)

I have installed package apache-airflow-providers-snowflake on airflow on docker and i am getting error > No module named Snowflake Please refer attachment (check the error mentioned for the...

Snowflake nodejs driver returns Unable to connect: Network error. Could not reach Snowflake

I'm using snowflake through VPN connection and need to setup snowflake on nodejs project. I followed these steps mentioned in https://docs.snowflake.com/en/user-guide/nodejs-driver-use.html#...

Snowflake connector "Cannot connect to Snowflake"

I was working with Kafka and try to connect snowflake with it but it's not connecting. It gives some kind of regional error that the server and cluster should be on the same region, and I tried it...

Snowflake: How to connect to snowflake using .NET Core

I am working on a new Project and requirement of the project is to design an API endpoint that connects with Snowflake using .NET Core As I am new to the Snowflake, I referred to the sample...

Snowflake Kafka connector, can't login

I am trying to use the Kafka Connect sink connector for Snowflake following instructions here: Snowflake docs. I can see in Snowflake that the account I created can successfully login via public...

Trigger Snowflake task when data pushed to Snowflake stage

I have 1 snowflake internal stage where I am pushing json files data through snowsql. Then I will run some queries using snowflake UI. Currently its all manual, is there anyway we can trigger...

Snowflake on Heroku Via ODBC

Update - I got it working by using Sequel and Ruby-ODBC gems and a different build pack for Heroku (https://elements.heroku.com/buildpacks/daasity/heroku-buildpack-snowflake-odbc) Had to amend...

Snowflake transformations

We will have flat files loaded into snowflake tables in staging schema from AWS S3. Now we need to perform simple transformations like aggregations, mapping, calculation etcetc. I know we can use...

Visio Stencil for Snowflake?

I want to design architectures that include Snowflake. My tool of preference is Visio; so I'm looking for Snowflake Visio stencils. My google searches have come up empty, and unfortunately...

Make background snowflake element unclickable

I have added a snowflake effect to my website to make snowflakes fall in the background on the homepage (Got code from https://www.kirupa.com/html5/the_falling_snow_effect.htm). It works by adding...

SnowFlake - Micropartition Extension

We understand that snowflake stores the data in MicroPartition of each 16 MB ( Is that understanding correct?). Does the MicroPartition files are stored in .FDN file extension ? Is .FDN is...

Snowflake Ruby odbc Assertion failure: GEOGRAPHY_type_unsupported

Connecting snowflake to a rails application using ODBC connector as recommended : https://community.snowflake.com/s/article/Ruby-Connectivity-Options-for-Snowflake And, as the rails odbc connector...

Snowflake DNS whitelisting

We are using snowflake enterprise edition. One of the client systems wants to access our snowflake account to consume the data. We have created user and password and share with them to connect to...

Snowflake - Privileges required to query snowflake Information schema views

I am new to Snowflake. Is it possible to query Information schema views for eg, SCHEMATA, TABLES, COLUMNS for all tables in a snowflake Db without having select access to the underlying tables....

Query Snowflake Jobs

I am new to Snowflake databases, but I come from a SQL Server background. Is there a way to query Snowflake jobs to see if any contain a certain table name?

Snowflake Task Functionality

Wanted to know if snowflake tasks allow you to execute a copy command from an external staged S3 bucket into a destination snowflake table as below. COPY INTO snowflaketable FROM...

How can I find my Snowflake bill within Snowflake?

Usually I get my Snowflake invoices through email, but I'd like to track my consumption within Snowflake. I've found a way to find my usage data from the console, but not mapped to actual...