Does Snowflake support correlated subqueries?
Yes, it does support correlated subqueries but they have to be correlated scalar subqueries in WHERE clauses. You can also find more information about subqueries in Snowflake at Can you perform nested queries in snowflake?
Can you perform nested queries in snowflake?
Nested queries (subqueries; a query within another query) can be performed in Snowflake. When the subqueries are in a WHERE or FROM clause, they are used to provide data that will be used to have a limit or compare the data that is returned by the containing query. There also are different types of subqueries: […]
Can I use the SELECT INTO syntax for Snowflake?
No, you cannot use the SELECT INTO syntax for Snowflake as it does not have that statement. However, there are other alternatives that can be used instead such as CREATE TABLE as SELECT statement in order to create a table by copying or duplicating the existing table or based on the result of the SELECT […]
Can I perform top 10 syntax in snowflake database?
Yes, you can perform top syntax in the snowflake database. It can be done by using TOP and this will constrain the maximum number of rows returned by statement or subquery. Important to Note: When you use TOP make sure that is a non-negative integer constant and also note that LIMIT is equivalent to TOP […]
What is zero copy cloning in Snowflake ?
Zero copy cloning in Snowflake is the feature that allows the duplication of an object without having to create a physical copy and without having to add any more storage costs. This can be done through the command word CLONE and this allows the creation of copies of tables, schemas, and databases. However, this feature […]
What is the difference between Fail-Safe and Time-Travel in Snowflake?
While they are both features that make sure you have access to your historical data, Fail-safe is a way to recover historical data in case there was a system failure or other type of failure, and Time Travel allows you to query, clone, and restore the historical data that is within the tables, schemas, or […]
What can you use for data profiling with the Snowflake database?
First, what is data profiling? It can be seen as looking at and analyzing data sources in order to create summaries. This helps gather information that companies can use to help their business. Data profiling is also important to ensure that your data is truly accurate of how your business is doing by seeing if […]
How many days is the time travel history preserved in Snowflake?
Actions such as querying, cloning, and restoring historical data from the tables, schemas, and databases are available for up to 90 days in Time Travel. However, this is within the Extended Time Travel which only comes from the Snowflake Enterprise Edition. This means that for the standard accounts the standard time for Time Travel is […]
What do you need to do to setup fail-safe in Snowflake?
Fail-safe is essentially always set up (always working) as a way to help you recover your data in case of any failures within the system. But if you need to restore this data from Fail-safe you would need to create a support ticket/case. There are two ways to create a support case: 1.The first way […]
Can I connect PySpark to snowflake?
Yes, you can connect PySpark to Snowflake as Snowflake is compatible with both Python and Spark. The Snowflake Connector for Spark, also known as Spark Connector, uses Snowflake within the Apache Spark system which allows Spark to read and write data to Snowflake.
What is Snowflake Time Travel?
Snowflake Time Travel gives access to historical data (which is any data that has either been changed, lost, or deleted). With Time Time Travel you can also: 1. Make clones of schemas, tables, or even databases 2. Restore these schemas, tables, and databases However, once the period of time that is defined has passed, the […]
What is fail-safe in Snowflake ?
Fail-safe protects historical data in case there is a system failure or any other failure. Fail-safe allows 7 days in which your historical data can be recovered by Snowflake and it begins after the Time Travel retention period ends. It is important to note that Fail-safe should only be used when all other recovery options […]
Is there a cost associated with Time Travel in Snowflake?
In short, Time Travel does have some storage fees imposed for maintaining historical data. The way that these fees are calculated is by each day (24 hours) from each time the data has changed. By maintaining only the necessary information to restore the roots from a table that has been updated or deleted, Snowflake lessens […]
I’m having trouble connecting to Snowflake from R. Any suggestions?
If you want to connect to Snowflake from R (RStudio) you will need to use the ODBC (Open Database Connectivity) driver on either Windows, MacOS, or Linux. Here are some steps on how to do this: 1. The first step is to create an ODBC DSN (Data Source Name) 2. Then you will test if […]
Having problems connecting to snowflake from Pentaho? Any suggestions?
First you want to make sure that the Pentaho version is the 6.1 version or above. Next, these steps will help you create the JDBC connection to Snowflake through Pentaho: 1. You will need to download the Snowflake JDBC driver to the workstation while at the same time running Pentaho 2. Then you will copy […]
What is Airflow?
Airflow is a platform designed to automate, schedule, and monitor workflows in an automated way. It is mainly used for data processing pipelines, computational workflows, and ETL processes. The tool can be customized to meet each need and this makes other tasks easier to complete. Some of the other features of Airflow include: 1. Directed […]
How do you add a stream to a table in snowflake?
You would use the command CREATE STREAM (or REPLACE STREAM) and it would create a new stream in the current schema or it would replace an existing stream. An example would be: create stream mystream on table mytable; The command also supports: -CREATE STREAM…CLONE (to create a clone of the existing stream) However, if change […]
Is there any consumption cost when you add a stream to a table in Snowflake?
Snowflake extends the data retention period for the source table temporarily when a stream is not consumed regularly. Regardless of which edition of Snowflake you have on your account, if the data retention period for the table is less than 14 days, behind the scenes it is extended to the smaller of the stream transactional […]
What does a Resource Monitor actual do in Snowflake?
Within Snowflake, it would be a resource monitor. Using resource monitors, you can set limits on how many credits are consumed through user-managed virtual warehouses and virtual warehouses used by cloud services. How many credits are consumed, would be based on the warehouse size and how long it runs. The resource monitor would set limits […]
What is Snowgrid?
Collaborating on a single copy of data has never been easier. Snowgrid is the perfect platform that allows you to discover and share data between teams, allowing for instant access to up-to-date information. The platform has built in governance controls and policies that follow the data, allowing for secure access and regulation across employees. The […]