Automatic Schema Inference using Amazon Redshift Query Editor V2 | Amazon Web Services

Published: 07 June 2023
on channel: Amazon Web Services

1,773

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

On this page of the site you can watch the video online Automatic Schema Inference using Amazon Redshift Query Editor V2 | Amazon Web Services with a duration of hours minute second in good quality, which was uploaded by the user Amazon Web Services 07 June 2023, share the link with friends and acquaintances, this video has already been watched 1,773 times on youtube and it was liked by 11 viewers. Enjoy your viewing!

51,140