Shreyansh Gupta

#TIL about #AWS data exchange that can be used to subscribe and make use of third party datasets in #Amazon Redshift.

#TIL that we can view query by query analysis for every query that has run on #AWS Redshift including execution plans.

#TIL about the different migration strategies that we can use to migration from one #database to another. 1. One step migration 2. Two steps migration 3. Iterative migration

#TIL about #AWS SCT that can be used to convert the schema for a source database to any supported database that is hosted on AWS.

#TIL about #AWS Snow family devices that include physical devices shipped to your place. These can be used to ship data in and out of AWS. @harichandana9014/aws-snow-family-e8ea524da1ab" target="_blank" rel="nofollow noopener">medium.com/@harichandana9…

#TIL about DDM that allows us to dynamically mask PII while querying data in #AWS Redshift.

#TIL that we can use current_namespace system variable in the view definition to create multi tenant views in #AWS Redshift.

#TIL that #SQL queries in modern databases can, in fact, use multiple indexes contrary to what I had earlier believed.

VACUUM recluster option in #AWS Redshift can be useful if our queries access only the most recent data.

#TIL that we can use the recluster option during VACUUM operation in #AWS Redshift to sort the unsorted table portions without merging the data with the automatically sorted portions of the table.

#AWS Redshift will even go as far as automatically creating MVs based on query patterns using the AutoMV feature.

#TIL that #AWS Redshift automatically converts queries to use MVs if an appropriate MV is present that can respond to the query.

#TIL about WLM in #AWS Redshift and how you can use queues, QMR along with catalog tables to optimize your workloads.

#TIL about concurrency scaling in #AWS Redshift and how it scales workgroups automatically to meet the change in the workloads.

#DoYouKnow That #AWS Redshift uses ATO (Automatic table optimization) to automatically optimize the tables by configuring sort keys, dist keys and encoding when the table is created with the AUTO option.

#TIL You can use Redshift ML to train and use ML models using familiar #SQL commands. No need to learn new tools.

#TIL about tool calling in architectures of #AI applications. The possibilities that this feature opens up are amazing.

A few lessons on showing up by @moretothat

#TIL The SQL Row values syntax can also be used in the WHERE clauses. It is most commonly seen in the INSERT statements. Check out the usage here - use-the-index-luke.com/sql/partial-re… #SQL #Databases

#DoYouKnow Ensuring that the database executes the query in a pipelined manner is more important than a fast execution! Read more here - use-the-index-luke.com/sql/sorting-gr… #SQL #Databases