Shreyansh Gupta @_backslashzero

💻 Software Engineer • Sharing my learnings guptashreyansh.github.io Joined August 2015

Tweets

136
Followers

33
Following

94
Likes

91

Shreyansh Gupta @_backslashzero

4 months ago

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

0 0 0 35 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

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

0 0 0 50 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

#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

0 0 0 48 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

#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.

0 0 0 39 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

#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. medium.com/@harichandana9…

0 0 0 31 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

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

0 0 0 35 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

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

0 0 0 33 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

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

0 0 0 37 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

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

0 0 0 38 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

#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.

1 0 0 43 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

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

0 0 0 34 0

View Details

Shreyansh Gupta @_backslashzero

5 months ago

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

1 0 0 38 0

View Details

Shreyansh Gupta @_backslashzero

6 months ago

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

0 0 0 38 0

View Details

Shreyansh Gupta @_backslashzero

6 months ago

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

0 0 0 43 0

View Details

Shreyansh Gupta @_backslashzero

6 months ago

#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.

0 0 0 55 0

View Details

Shreyansh Gupta @_backslashzero

6 months ago

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

0 0 0 61 0

View Details

Shreyansh Gupta @_backslashzero

6 months ago

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

0 0 0 67 0

View Details

Ryan Hawk @RyanHawk12

2 years ago

A few lessons on showing up by @moretothat

1 2 14 2K 7

View Details

Shreyansh Gupta @_backslashzero

2 years ago

#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

0 0 1 98 0

View Details

Shreyansh Gupta @_backslashzero

2 years ago

#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