This is a demo of the new file automatic schema inference feature while loading data into a new table in Amazon Redshift using Redshift Query Editor v2. A user can browse S3 locations or local file system for datasets and load them into a new Amazon Redshift tables by automatically detecting schema of the files.
0:00 Intro
1:22 Detect CSV file schema and load from local file system
6:42 Detect Parquet file schema and load from Amazon S3
10:46 Detect JSON file schema and load from local file system
Learn more about loading data with QEv2 - https://go.aws/40tmZam
Learn more about Amazon Redshift - https://go.aws/3mGbPwL
Subscribe:
More AWS videos: https://go.aws/3m5yEMW
More AWS events videos: https://go.aws/3ZHq4BK
Do you have technical AWS questions?
Ask the community of experts on AWS re:Post: https://go.aws/3lPaoPb
ABOUT AWS
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers — including the fastest-growing startups, largest enterprises, and leading government agencies — are using AWS to lower costs, become more agile, and innovate faster.
#AmazonRedshift #QueryEditor #QEV2 #Data #AWSDemos #AWS #AmazonWebServices #CloudComputing
