How to migrate on-premises Oracle Exadata environment to Snowflake without using any third-party tools. Your suggestions and recommendations are most welcome.| Snowflake - Latest posts
Hey Everyone! Jeff Hollan here - product manager working on Snowflake Intelligence. Wanted to share some updates for November. I plan to use this forum to post updates as new features roll out, and help answer questions from builders and users of Cortex Agents and Snowflake Intelligence. Here’s the November update below: GENERAL AVAILABILITY - Snowflake Intelligence, Cortex Agents, and MCP Server are all now Generally Available. This is across all clouds and regions (except gov cloud), but ...| Snowflake - Latest posts
Hello, I was following this (8 months old) YouTube video about graph analytics in Snowflake with Neo4j: https://www.youtube.com/live/jBge7wk4tS4 In the notebook, some packages are installed with pip install !pip install plotly networkx --upgrade When I try to do this in my notebook, it states “pip install” isn’t supported yet. To install packages, use the package selector at the top of the page. and throws when executed File "Cell [cell1]", line 1, in <module> get_ipython().system('pip ...| Snowflake - Latest posts
Hi Team, I’m working with a Snowflake Python stored procedure that uses the SECRETS clause to access credentials for external API calls. Here’s a simplified version of my current procedure: CREATE OR REPLACE PROCEDURE KIPI_DEV.RAW.Procedure_MULTI_secret(secret_list ARRAY) RETURNS VARCHAR LANGUAGE PYTHON RUNTIME_VERSION = '3.10' PACKAGES = ('snowflake-snowpark-python','requests') HANDLER = 'main' EXTERNAL_ACCESS_INTEGRATIONS = (API_INTEGRATION) SECRETS = ( 'api' = API_CREDENTIALS ); This w...| Snowflake - Latest posts
Hi Everyone, I am building an AI agent using Cortex Analyst and Search for Snowflake Intelligence. I need to add an “export data as csv” functionality for the user queries. Once users are done doing their analysis, they can ask a follow-up question to export that data into a csv. AI Intelligence should either provide downloadable link on the same UI or send an email with the csv attachment. P.S. We can’t use Streamlit application. Thanks in advance, Vipin| Snowflake - Latest posts
Everything was working then suddenly the comand raise the error [WinError 32] How do I fix that? What program could be using the files needed for write_pandas? Is there an alternative to append a df to a table? I could use create_dataframe but the I would need to create my identity column inside my dataframe. My table CREATE OR REPLACE TABLE GOLD.fato_variavel ( id_variavel_peticao INT AUTOINCREMENT PRIMARY KEY, – chave primária gerada automaticamente ID_VARIAVEL INT id_cliente INT NOT NUL...| Snowflake - Latest posts
We are evaluating tools for doing ERDs, lineage, lite SQL editing, and modeling. There’s a few tools that seem decent and am wondering if anyone can give me their feedback on these or tell me what you are using. I am looking at DBeaver, DBVisualizer, and Vertabelo. I ruled out a few based on cost, one in particular, sqlDBM. If you’re using these, would love insights, and if you’re using something else, tell me what else to look at! thanks!| Snowflake - Latest posts
Hello, Working with data effectively requires a deep understanding of its functional context. Currently, we rely on external tools like Confluence or SharePoint to manage documentation, which creates fragmentation and slows down workflows. I’d like to suggest the addition of a native documentation manager within Snowflake, focused on functional data knowledge. This feature would allow teams to document business logic, data definitions, and use cases directly within the Snowflake environment...| Snowflake - Latest posts
I am the ACCOUNTADMIN of my Snowflake account. When attempting to log in to the Snowflake web console, I am presented with a “Verify with Passkey” screen. The login process fails with the message: “No passkeys available — There aren’t any passkeys for snowflakecomputing.com on this device.” Because of this, I cannot log in to the console to disable passkey authentication. I attempted the following workarounds: Tried using ?disablePasskey=true and ?showClassic=true URLs — the sam...| Snowflake - Latest posts
I’m attempting to set up OAuth authentication for Claude Desktop’s available Snowflake Connector, but the authorization consistently fails with “Error occurred in authorization - The requested scope is invalid.” I’ve tried troubleshooting it with Claude as well, but it is not working for me. This is my first time setting up an OAuth connection for my account. Setup Details: I’ve created a dedicated CLAUDEAI role and configured a custom OAuth security integration. Here are all the ...| Snowflake - Latest posts
Hello dear friends, I am trying to send a JSON payload from Snowflake to a function app in the Azure. I know how the payload should look like but as you know, two platforms are involved here, we wouldn’t be sure if the errors we get are technical issues or policy issues. I know how the syntax code should look like getting it from this documentation: Step 3: Create the API integration for Azure in Snowflake | Snowflake Documentation I’ve used this coding structure : CREATE OR REPLACE API I...| Snowflake - Latest posts
Current Behavior: Snowflake’s lineage feature visualizes data flow between tables, views, and other objects — but it does not show who has accessed or is actively accessing those tables. Opportunity: Enhance lineage to include user-level access flow, showing which roles or users have queried, modified, or interacted with specific tables over time. Why This Matters: Improves data governance and auditability by linking data movement to user behavior. Enables faster impact analysis during s...| Snowflake
Hi Team, I am new to Snowflake, and started learning: question is 1.when I copy into from s3 bucket where file is kept and I am not knowing how many columns and column name then how to create in worksheet with column name as per my undertsanding we need to mention as col1, col2, col3 and if col exceeds it will filled with null later will do alter table, will this approach is correct? 2 question is in s3 bucket excel file have 10 columns but i need only few columns how to do?| Snowflake - Latest posts
Hi @Cesar_Segura Is this the form we’re supposed to use? It’s from 2024?! 2024 Data Superheroes Application Ferhat AOUAGHZENE| Snowflake - Latest posts
I’m struggling to understand the best approach to load data FROM an on-premises SQL Server into SnowFlake FROM SnowFlake and not pushing data from the on-premises environment. We are hosted on AWS, however we do not have a dedicated VPC environment or any kind of private link setup, so I’m unsure how to talk between SnowFlake and on-premise. In tools like Power BI/Fabric, we have the Data Gateway installed on an on-premise server which allows me to use Fabric to PULL data from on-premises...| Snowflake - Latest posts
In Snowsight, when viewing the roles graph, database roles are not shown. It would be very helpful to have a toggle or button to include database roles in the visualization. This would give a complete overview of role relationships and make permission management much easier.| Snowflake - Latest posts
It would be great if Snowsight allowed light customization of its visual theme. In CI/CD setups where each environment has its own Snowflake account (e.g. DEV, TEST, PROD), it’s currently hard to tell which environment you’re in at first glance. A simple visual cue would help prevent mistakes and make navigation much easier.| Snowflake - Latest posts
Hi everybody, with “DESCRIBE CORTEX SEARCH SERVICE my_srv” I can see a column named “auto_suspend”. I try to set it with : ALTER CORTEX SEARCH SERVICE my_serv SET AUTO_SUSPEND = 3600 ; But it does not pass .. I looked in the documentation and it does not mention it. Does anybody have already enforce this value ? Bests, Florence| Snowflake - Latest posts
Hi @sparthas Following up on this thread, currently I am trying to connect a published Power BI dashboard with Snowflake production instance (which is not integrated with AAD/SSO) for dataset refresh, we have setup the Power BI gateway on a VM and placed it in the same VNET, so its reachable to Snowflake production. I can see the gateway in the Power BI portal, now when I am trying to create a connection using the gateway and authenticating using Snowflake credentials, it fails. Any idea what...| Snowflake - Latest posts
I am trying to run a while loop within execute immediate block. This works fine on snowsight and VSCode snowflake extension, but it fails with liquibase CICD. How to resolve? Github copilot suggests to use Liquibase’s splitStatements and endDelimiter. If this doesn’t work, are there any other delimiters that can be used instead of $$? --liquibase formatted sql --changeset PPD_RELEASE:PPD_RELEASE_20251030_62301 splitStatements:false endDelimiter:$$ stripComments:false EXECUTE IMMEDIATE $$ ...| Snowflake - Latest posts
Hi Community, I’ve noticed a small but recurring inconvenience when working with task DAGs in Snowflake. Once a DAG tree starts executing - especially with multiple dependent tasks - there’s currently no simple way to stop the entire execution if needed. This can happen when: A CI/CD deployment triggers all ETL workflows, even though only a few systems were impacted. A data or configuration issue is found mid-run, but all child tasks keep running. Having the option to cancel the whole DAG...| Snowflake - Latest posts
Hi Snowflake Certification Team, I registered for my Snowflake certification exam using my personal email address. Later, I created another account using my company email address. After updating my company email on the personal account, it seems that duplicate profiles were created, and I am now unable to log in to either account. I have an exam scheduled for today and another one on Monday, so I urgently need help regaining access Thank you for your prompt assistance.| Snowflake
I received a last-minute email from Snowflake on 31 Oct 2025 indicating they are making a price change to the Cortex API the next day, but they provided no details, and it’s not even mentioned on their documentation website, which is quite odd. Does anyone have more information about this? It seems unusual for Snowflake to make such significant changes at the last minute and account representative has no more details than the email saying…. Below are the details of the email I received on...| Snowflake - Latest posts
To provide more context, I am using a remote desktop provided by my client. I am logging into Snowflake through the web browser within this client’s remote desktop environment. My current hypothesis is that the network configuration of this remote desktop might be interfering with the login process for the OpenFlow Canvas.| Snowflake - Latest posts
Hi @all Is there a way to generate documentation for a dbt project in Snowflake, similar to what is done in dbt Cloud using the dbt docs generate command? Ferhat AOUAGHZENE| Snowflake - Latest posts
Currently, using select get_ddl(‘database’, ‘my_db’); or select get_ddl(‘schema’, ’my_db.my_schema’); Excludes semantic views and therefore who knows what else! I suggest these two commands must return the ddl for ALL objects defined in the given database/schema otherwise the value of said commands is completely undermined: you might think you’re getting the ddl to create an entire database/schema, but you’re not! I recently took over the administration of a large Snowflak...| Snowflake - Latest posts
Good evening, We are in region AWS_EU_WEST_1 and as per the documentation we are able to get Cortex Analyst. We had access but last days we are getting the following error: The required LLMs for Cortex Analyst are not available in your region or not authorized. Please contact your administrator. Which can be the reasons? Thanks| Snowflake - Latest posts
I have a Snowpark Python code snippet which I translated from a Snowflake SQL. Snowflake SQL: WITH pat_base AS ( SELECT * FROM MOD_DB.TEST.PATIENT_TABLE ), pat_id AS ( SELECT A.PATIENT_SURRG_ID, A.SELECTED_DATA_SOURCE_TRACK_ID_REF, f.value:value::string AS “PID.PID.3.CX.1_Patient_Identifier_ID1”, A.FHIR_BIRTH_DATE AS “PID.PID.7_Date_of_Birth” FROM pat_base A, LATERAL FLATTEN(input => A.FHIR_IDENTIFIER) f QUALIFY ROW_NUMBER() OVER (PARTITION BY A.PATIENT_SURRG_ID ORDER BY f.index) = 1 ...| Snowflake - Latest posts
We are attempting to load data from a Postgres source using CDC and Openflow using BYOC in AWS. We pruned our load down to two tables to zero in on the problem. When the initial snapshot runs, we are seeing rows missing from the destination Snowflake table. Looking at the counters we see that the number of rows read from the source is correct, but the number of rows being sent to the PutSnowpipeStreaming processor is much lower then the number of rows read. We are seeing messages in the count...| Snowflake - Latest posts
Hello All, We don’t have the exact data volume or same jobs/workload available in non-prod environment as its running in production. However, we want to take a decision on moving our workloads to Gen-2 warehouse, to have cost benefit without compromising the performance. As per the documentations, Gen-2 best suited favors heavy DML specific workload and we do have large Insert/Update/Delete/CTAS/Merge queries runs as part of the data transformation. And also, now snowflake optima help the q...| Snowflake - Latest posts
I am trying to flatten the data using the below query but somehow I am unable to achieve the desired output. Kindly suggest where I am going wrong. Desired Output : Column 1 Column 2 Column 3 IT Sachin Karunadu Application Developer IT John Doe System Analyst HR Jane Smith HR Manager| Snowflake
The data was inserted in snowflake at 3:16am utc and time travel shows the data from that time when provided with at timestamp. Checked from 3:16 to 4:45am utc and the data is available in time travel. But when we did query using select statemnet during this time the select wuery did not return the data. Is there any reason and can commit be the reason for data to be available in time travel but not when we perform select query| Snowflake - Latest posts
Our very large app uses many postgres databases, but our organisation uses snowflake. We have been trying for more than one year to get our spring boot app to connect to snowflake using a DataSource (not jdbc), and so far all attempts have failed. We have to use a DataSource as this is required by flyway for schema migrations (it doesnt work with a low level Connection as it creates multiple connections). The crux is we can decode the key with the passphrase (which is stored in aws secrets ma...| Snowflake - Latest posts
In Snowsight–> Cost Management –>Consumption–>Usage Type: Data Transfer, we see huge data transfer(>10TB) for COPY action on certain days. On other days the Data transfer is normal. I want to know how we can dig down to identify user/query that is causing this.| Snowflake
Hi Guys, I created a Streamlit App in Snowflake, now i want to share this app to my users, my users will login app and enter some details and then submit them. can anyone please help, how i can share this app with my users? Thanks in advance.| Snowflake
I’ve developed a procedure in Snowflake Scripting that performs several DML operations, including statements. I’m looking for a way to verify that all the INSERT` operations completed successfully, without relying on a RESULT SET ? Can you help me please ?| Snowflake
Hello, Snowflake Community I’m tracking Snowflake credit usage by user using QUERY_TAG values, where each user’s email address is assigned as the tag (e.g. 'johndoe@email.com'). To pull query and credit data, I use SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY. The results generally look fine, but I’ve noticed that some rows have a NULL or empty WAREHOUSE_SIZE. Here’s a simplified version of the query I run and the result in the screenshot.: SELECT qh.query_tag, qh.database_id, qh.sche...| Snowflake
Update (6-10-24) As part of our commitment to transparency around our ongoing investigation involving a targeted threat campaign against some Snowflake customer accounts, cybersecurity expert Mandiant shared this blog post today detailing their findings to date. As we shared on June 6, we continue to work closely with our customers as they harden their security measures to reduce cyber threats to their businesses, and we are developing a plan to require our customers to implement advanced s...| Snowflake
