Frank Bell | Answers

I wrote an in depth article to cover this in more detail here: https://snowflakesolutions.net/snowflake-solutions-center-by-dataops-live/ but the simple answer is that the Snowflake Solutions Center also...

View Question
0 Votes

I wrote an in depth article to cover this in more detail here: https://snowflakesolutions.net/snowflake-solutions-center-by-dataops-live/ but the simple answer is that the Snowflake Solutions Center also...

View Question
0 Votes

I wrote an in depth article to cover this in more detail here but the simple answer is that the Snowflake Solutions Center also known as the SSC within Snowflake for Sales Engineers and Field CTOs, is...

View Question
0 Votes

Yes, you can create and apply a row access policy with EXTERNAL TABLES by applying it to the VALUE column of an existing external table. You do this by executing an ALTER TABLE statement against that external...

View Question
0 Votes Selected

Yes. The way it works  is that Snowflake EVALUATES the Row Access Policy FIRST and THEN the data masking policy. Also, note that if you do have BOTH a Row Access Policy and a Data Masking Policy associated...

View Question
0 Votes

There are two ways to apply a Row Access Policy (RAP) to a table or view. You either add it to the create table or create view statement or you add it by altering the table or view as follows:\n\n* CREATE...

View Question
0 Votes

If you want to ADD an IDENTIFY COLUMN in a Snowflake table, you just need to either:\n\n1. CREATE the TABLE with the IDENTITY VALUE LIKE THIS:\n\nCREATE OR REPLACE TABLE EXAMPLE_TABLE(\n YOUR_ID IDENTITY...

View Question
0 Votes

Hey Charlie - This is definitely an annoying "gotcha". The problem is that on the secondary account itself where the Replica Database will be created has to be ENABLED for REPLICATION currently by ONLY...

View Question
1 Vote

[I get asked this question all the time so I'm answering it.] Snowflake Micro-partitions are immutable physical files that are automatically partitioned based on ingestion order unless you setup auto-clustering...

View Question
1 Vote

YES. Streams are one of the objects you can clone. Its as simple as:\nCREATE STREAM SNOWFLAKE_SOLUTIONS_STREAM_CLONE FROM SNOWFLAKE_SOLUTIONS_STREAM_BEING_CLONED;\nOther objects you can clone are: DATABASE,...

View Question
0 Votes
Load more answers