Frank Bell | Reputations

Posted an answer
What is the Snowflake Solutions Center?

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...

March 13, 2024 6
Posted an answer
What is the Snowflake Solutions Center?

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...

March 13, 2024 6
Posted an answer
What is the Snowflake Solutions Center?

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...

March 13, 2024 6
Asked a question
What is the Snowflake Solutions Center?

What is the Snowflake Solutions Center?

March 12, 2024 1
Received an upvote
October 17, 2023 2
Asked a question
My Fivetran sync just failed, how can I troubleshoot it?

My Fivetran sync just failed, how can I troubleshoot it?

March 26, 2023 1
Asked a question
My Fivetran Google Sheets Connector was syncing to table in database, can you change column name?

We are using the Google Sheets Connector in Fivetran. If I change a column name in the first row will it get changed in the database table destination?

March 26, 2023 1
Selected an answer as best
March 19, 2023 2
Answer was selected as best
March 19, 2023 10
Received an upvote
February 10, 2023 2
Posted an answer
What happens when a table has BOTH a data masking policy and a row access policy applied to it? Does it use both?

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...

November 19, 2022 6
Posted an answer
How can I apply a Row Access Policy to a Table or View?

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...

November 19, 2022 6
Posted an answer
Can I use a row access policy with an external table?

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...

November 19, 2022 6
Asked a question
I cannot see how I can switch back to the Classic Console with new Snowflake account

I recently created a new Snowflake Account but I cannot see how I can switch back to the Classic Console. Is there some secret hidden way I can go back to the Classic Console or has it actually been removed?

November 17, 2022 1
Asked a question
What is Streamlit?

What is Streamlit and why did Snowflake acquire it?

November 17, 2022 1
Asked a question
What is private data sharing on Snowflake?

What is private data sharing on Snowflake and how does it work?

November 17, 2022 1
Posted an answer
How can I create test databases on Snowflake that are the same as production?

One of the awesome features of Snowflake is NO COPY CLONING. You can utilize the CREAT DATABASE NEW_CLONED_TEST_DATABASE CLONE EXISTING_DATABASE_NAME; It is that easy to create a clone of your production...

November 15, 2022 6
Posted an answer
Can I create BOTH a MASKING POLICY and ROW ACCESS POLICY on the same table or view?

Yes, you can create and apply a row access policy and a data masking policy on the SAME table or VIEW but not on the same exact column.

November 15, 2022 6
Posted an answer
I know I can have row access policy and masking policy on same table but can I actually have them on the same column?

As of now, you CANNOT specify the same exact column in both a row access policy and a data masking policy.

November 15, 2022 6
Posted an answer
What is a TASK object in Snowflake? What does it do?

If you are familiar with cronjobs, I view Snowflake Tasks as kind of similar. When TASKS were introduced in ____ with Streams I was kind of surprised because I thought Snowflake kind of was starting to...

November 15, 2022 6
Load More