From the course: Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Defining a schema

Defining a schema

From the course: Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q

Start my 1-month free trial Buy for my team

Defining a schema

“

- [Speaker] Oftentimes, as data analysts and data scientists, we are invited very late into the digital transformation project as experts to analyze data and provide our insights. We may not be included in the scoping or discovery sessions. Without domain knowledge of the data. We need to quickly get up to speed to understand the data modeling and how can we use data to answer our business questions. Data understanding is part of the data analytics workflow where we explore different tables, variables, data types, and relationships. As analysts, it is used to have some background knowledge about the data and understand the schema. Lucidchart describe a database schema as a logical configuration for SQL databases, a schema includes metadata such as data types, column names, tables, and also databases. As a senior data analyst or data scientist, as best practice, we may sketch our data model for our project to illustrate the data flows and also how different tables in our database are…

Contents