snowflakepoc.staged-by-discourse.com Open in urlscan Pro
2602:fd3f:3:ff01::2b  Public Scan

Form analysis
1 forms found in the DOM

POST /login

<form id="hidden-login-form" method="post" action="/login" style="display: none;">
  <input name="username" type="text" id="signin_username">
  <input name="password" type="password" id="signin_password">
  <input name="redirect" type="hidden">
  <input type="submit" id="signin-button" value="Log In">
</form>

Text Content

Skip to main content

Sign Up Log In
 * 
 * 
   




SNOWFLAKE COMMUNITY FORUMS

We're happy to have you here. If you need help, please search before you post.


All outgoing email has been globally disabled by an administrator. No email
notifications of any kind will be sent.

    
 1. categories
    
 2. tags
    
    
 3. all
    
    

 * Latest
 * Hot
 * Categories
   
 * 
 * Ideas
 * Docs
 * University
   




MONTHLY LEADERBOARD

Rank Cheers



POPULAR TAGS

knowledge-base column tables use-manage-data-applications account function date
copy aws schema
View all

Topic list, column headers with buttons are sortable. Topic Posters Replies
Likes Views Activity


Its a new idea. Lets evaluate and see
Ideas
0 votes
A fresh idea is one that is novel, breaking new ground in a particular field. It
might be a groundbreaking scientific theory or an innovative solution to a
long-standing problem. 0 5 29d


Lets see how it looks on Idea
Ideas
1 vote
Include commonly used words in your topic so others can find it. To group your
topic with related topics, select a category (or tag). 0 3 30d


How to get root object from inside a snowflake notebook?
Python
Following simple test want write file into notebook int stage: # Import python
packages import streamlit as st import pandas as pd # We can also use Snowpark
for our analyses! from snowflake.snowpark.context import get… read more 1 4 Sep
17


Python Error 100357
General
error-messagepython-snowflake
Some background, I have very little experience using Python or Snowpark. So, the
issue is probably very basic. We had a consultant make code connecting to our
financials website. It was working when they handed it over,… read more 0 2 Sep
17


Snowflake REST API for List Table not returning owner
Snowflake
rest-api
Hey folks, I’m running into an issue where the endpoint: GET
/api/v2/databases/database/schemas/schema/tables Is not returning the owner or
owner role type. However, when I use the query to fetch a single table, the ow…
read more 2 13 Sep 17


Any way to make COPY GRANTS parameter coming with DDL by default?
General
Hello, As per topic. I’m a team leader and I can’t count how many times
developers “forgot” to add the copy grants when recreating views, basically
smashing all previous grants. You can argue “get better developers”, b… read
more 5 4 17 Sep 17


Custom message in custom exception question
General
I’m writing a custom exception handling but my custom except is getting wrapped
into STATEMENT_ERROR that I’m trying to avoid. See my test stored proc example
and result. CREATE OR REPLACE PROCEDURE dev_psa.UTILITY.lg_e… read more 0 6 Sep
17


Google workspace SSO with Snowflake
General
sso
Hi, I am trying to create a SAML 2.0 SSO using Google Suite as an IDP. I
followed pretty much everything which is mentioned in the link here. But is
throwing the HTTP 404 as soon as I hit the SSO button while logging t… read more
0 6 Sep 17


Power Bi to Snowflake . Setup a connection through PBI Gateway or Direct
connection
General
Hi Team, We are pulling data from Snowflake into PowerBi Service (mostly
Dataflows). Currently we use Snowflake > PBI Gateway > PBI Service method. PBI
Gateway is installed on a VM that based in one datacenter (on pre… read more 0 6
Sep 17


Extract dataframe a xlsx from Snowflake notebooks
General
I have had some success with snowflake dashboard for some users. For cases where
I want better charting and data manipulation options, Snowflake notebooks seem
perfect. However, I have been unable to figure out how to … read more 2 14 Sep
17


Polaris Catalog Sync
General
Hi, I created Polaris catalog, followed all the connection creation steps, etc.
But still it doesn’t seem to work. I create catalog integration like: CREATE OR
REPLACE CATALOG INTEGRATION ICEBERG_GCS CATALOG_SOURCE … read more 0 3 Sep 17


How to escape “_” character in SHOW TABLES LIKE?
General
I could not find any solution in the documentation. For the LIKE command there
is an ESCAPE clause but when I try to use it in SHOW TABLES LIKE command the
clause seems to be missing. I need to show tables where the und… read more 2 1
10 Sep 17


I need to delete multiple worksheets. Snowsight will only let me select and
delete one at a time. Is there a way to do this efficiently, or am I stuck
spending hours deleting one workbook at a time?
Snowsight/UI
I need to delete multiple worksheets. Snowsight will only let me select and
delete one at a time. Is there a way to do this efficiently, or am I stuck
spending hours deleting one workbook at a time? 7 10 229 Sep 17


How to select UDTF output in snowpack
General Discussion
functionsnowpark
In SQL, I’m able to do something like this and it works: SELECT output.name,
output.score from input_data , TABLE( some_scoring_udtf( user, name,
review::string ) OVER (PA… read more 0 4 Sep 17


Transfer Snowflake Schema Ownership Without Revoking Fivetran Role Privileges?
General
schemarolefivetranpython
I tried to ask this in a different forum but didn’t got any replies, so
apoligise if you find this via google outside from here. So I’m trying to design
a solution to provide access to certain users to confidential data… read more 0
7 Sep 17


Sql stored procedures with EXECUTE IMMEDIATE and dinamic querry
Snowflake Community Questions
Hi all. I have a problem with stored SQL procedures in Snowflake. I have db1
with schema1 and schema2. In schema 1 i created 2 tables and in schema 2 i
created 3 sql procedures. Basically i have a main procedure that nee… read more
4 23 Sep 16


Send email with table data
General
I want to send auto email in complete table data in snowflake please can you
help anyone 4 1 22 Sep 16


Snowflake Kafka connector encrypted key Extra data detected in stream
Snowflake
kafkaconnector
Hello All, Following the below url to set up Snowflake kafka connector
https://docs.snowflake.com/en/user-guide/kafka-connector-install#using-key-pair-authentication-key-rotation
I then use the private key and pass ph… read more 3 13 Sep 16


REST API request - how to retrieve user name with . or @ characters
General
rest-api
Hey, I am sending a request for:
{{baseURL}}/api/v2/grants/user/name.last@email.com?showLimit=10 The login name
is an email attribute. As the following example - List of privileges associated
with this grantee type… read more 3 1 15 Sep 16


[possible docs typo] materialized view on reader account
SQL
reader-accounts
Is it just me that found in Manage reader accounts | Snowflake Documentation
something perplexing suggesting the creation of materialized views by reader
accounts? I’m aware reader account is mainly to SELECT data fr… read more 4 1 23
Sep 16


How to provide the input values to a snowflake notebook
Python
I have few queries in Snowflake notebooks do we have input variables in
snowflake notebooks? Like in Databricks TEXT widget to accept the input values
to the notebook? Do we have the similar functionality in snowflake? … read more
10 29 Sep 16


Best practices posting in Snowflake Forum
Announcements
best-practicesforum
Hi Snowflake Community In order to getting a good quality forum acknowledge
repository, we have to put pur efforts when we post our doubts / concerns
applying some best practices. I would like t… read more 3 4 20 Sep 16


DORA DWW05 Query Execution
SQL
Hi, Team can anyone help me on this issue, im trying to execute the dora dww05
query, but getting this error [ { “_”: “:no_entry:”, “actual”: 5, “description”:
“ROOT_DEPTH row count”, “expected”: 3, “passed”: fal… read more 2 16 Sep 16


S3 stage not reading new files
General
aws
I am trying to build an LLM bot similar to here: Build a Retrieval Augmented
Generation (RAG) based LLM assistant using Streamlit and Snowflake Cortex Search
With the only difference being that the stage will point to m… read more 1 9 Sep
16


How to import CSV file into Notebook and infer data types
General
Hello, I have a CSV file in external stage, and I want to import into Notebook
from that stage and store it in python data frame to infer data types and read
column headers and create the table in snowflake based on thi… read more 1 1 18
Sep 15


Snowpark temp stage
Python
tablesinternal-stage
I have been using Snowflake to do ML works. I have built a Multiple linear
regression. I am writing an output df as a table using session.write_pandas. I
get this error 'SQL compilation error: Object 'SNOWPARK_TEMP_STAG… read more 1
10 Sep 15


How to copy files from stage to sub folder in the same stage
Storage Patterns
I’m trying to copy a file into subfolder within same stage, though the subfolder
doesn’t exist yet. In theory this should work, but running “cell7” returns
nothing. Not sure why it is not working, I included the precedin… read more 3 18
Sep 15


Migration from Sybase to snowflake. We have rowid function in Sybase , which
function can be used equivalent in snowflake
Snowflake Community Questions
function
Below is the Sybase query. insert into table1 select t.esmp esmp,t.rowid rowid
from (SELECT  esmp, rowid(table2) rowid,updated,RANK() OVER(PARTITION BY esmp
ORDER BY updated,rowid DESC) AS rank FROM table2) as t wh… read more 2 27 Sep 14


Guidance - User level security
Governance & Security
I have general/common users 1. UI web page 2. DBT (CLI) load to access
snowflake. I can able to setup the network policy for the UI user access the
snowflake from UI page. How can secure the DBT user for the DBT loads. W… read
more 3 3 21 Sep 14


Delete Duplicate records
General
I am trying to delete duplicate records using the following code: ;WITH
cte_duplicates AS ( SELECT [ahpranum], ROW_NUMBER() OVER(PARTITION BY [ahpranum]
order by [AHPRANUM]) RowNumber from MC001_HCP_PROFILE_DATA … read more 3 1 34
Sep 14











Invalid date Invalid date