SQL Archieven - Nimbus Intelligence

Dec 01

Macros in dbt

By Luca Balduzzi dbt, Jinja, SQL, Uncategorized No Comments

Macros in dbt are reusable pieces of code that ensure that the code is ‘DRY’ (don’t repeat yourself), making it easier to understand and quicker to write. If you’re interested…

Nov 17

Love0

Killing JSON: Using Flatten to Load JSON Data

By Edoardo Draetta Data Load, JSON, Snowflake, SQL, Unstructured Data No Comments

Welcome back to Killing JSON, the series in which I channel my frustration with loading data into teaching you something. Last week, we covered the ins and outs of the…

Oct 13

Love0

Semi-structured data in Snowflake

By Chris Verweij Data, Data Load, Snowflake, SQL One Comment

The easiest form of data to load into a SQL database is fully structured. Comma separated values (CSV) files can be loaded into a tabular structure without any further transformations.…

May 30

Love0

Modern Data Stack in One Day

By Kris Winnubst Academy, dbt, Fivetran, Snowflake, SQL

At Nimbus Intelligence Academy we are trained to build a modern data stack including data warehousing, ELT processes and scheduled refreshing of data. Each trainee has set up a modern…

May 22

Love0

Column Level Security

By Mario Calise Data, Data Load, Data Visualization, Snowflake, SQL

Snowflake, as a modern cloud database, has the functionality to mask sensitive data for unauthorized users through Data Governance Features. In this blog, we are thus going to present Dynamic…

May 18

Love0

Conversion Functions- Part1

By Niccolo Racioppi Academy, Data, Database, Snowflake, SQL, Uncategorized

Conversion functions allow a data item of one datatype supported by Snowflake to be transformed into another datatype.The functions are numerous and are divided by family. Let's take a look…

May 18

Love0

INFORMATION SCHEMA

By Niccolo Racioppi Data, Database, Snowflake, SQL, Uncategorized

The Information Schema is a tool full of potential that allows us to keep track of numerous aspects of our account and the database in which it exists.Further proof of…

May 18

Love0

S10. What’s under the Snowflake(s)?

By Sofia Pierini Data, Frosty friday, Snowflake, SQL

Do you want to keep secure your data? Then, let's dedicate this new post of What's under the Snowflake(s)? about secuity! We focus on the challenge of Week 39 -…

May 18

Love0

S7. What’s under the Snowflake(s)?

By Sofia Pierini Data, Frosty friday, Snowflake, SQL

Do you want to keep secure your data? Then, let's dedicate this new post of What's under the Snowflake(s)? about secuity! We focus on the challenge of Week 39 -…

May 17

Love0

Snowflake’s INFER SCHEMA

By Mario Calise Data, Data Load, Database, Pipes, Snowflake, SQL

In this blog, we are going to discuss how Snowflake allows to easily interpret semi-structured data through its Schema Detection feature. This feature helps gaining time when setting up the tables…