@_backslashzero profile picture
Shreyansh Gupta @_backslashzero

💻 Software Engineer • Sharing my learnings

Joined August 2015
  • Tweets 136
  • Following 94
  • Followers 34
37 Photos and videos
#TIL about #AWS data exchange that can be used to subscribe and make use of third party datasets in #Amazon Redshift.
33
#TIL that we can view query by query analysis for every query that has run on #AWS Redshift including execution plans.
48
#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
46
#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.
38
#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/@harichandana9014…

AWS SNOW FAMILY

In this article, we will go through what is snow* and their advantages.

medium.com
30
#TIL about DDM that allows us to dynamically mask PII while querying data in #AWS Redshift.
34
#TIL that we can use current_namespace system variable in the view definition to create multi tenant views in #AWS Redshift.
32
#TIL that #SQL queries in modern databases can, in fact, use multiple indexes contrary to what I had earlier believed.
36
#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
42
VACUUM recluster option in #AWS Redshift can be useful if our queries access only the most recent data.
37
#TIL that #AWS Redshift automatically converts queries to use MVs if an appropriate MV is present that can respond to the query.
1
37
#AWS Redshift will even go as far as automatically creating MVs based on query patterns using the AutoMV feature.
33
#TIL about WLM in #AWS Redshift and how you can use queues, QMR along with catalog tables to optimize your workloads.
37
#TIL about concurrency scaling in #AWS Redshift and how it scales workgroups automatically to meet the change in the workloads.
42
#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.
54
#TIL You can use Redshift ML to train and use ML models using familiar #SQL commands. No need to learn new tools.
60
#TIL about tool calling in architectures of #AI applications. The possibilities that this feature opens up are amazing.
66
Shreyansh Gupta retweeted
Ryan Hawk
@RyanHawk12
13 Dec 2024
A few lessons on showing up by @moretothat
1
2
14
1,499
#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/p… #SQL #Databases
SQL row values syntax.

ALT SQL row values syntax.
1
97
#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/s… #SQL #Databases

Effects of ORDER BY and GROUP BY on SQL performance

An index can improve ORDER BY and GROUP BY performance in SQL databases.

use-the-index-luke.com
1
63
Load more