Granting Alter Table in Redshift
Okay, I will admit. I have been dealing w/ Redshift and all of its “isms” over the past several months and it is relatively.
Airflow Hate
Airflow is quickly working its way up the ranks on the list of things I hate. Just trying to get a monthly job to.
Why I Hate Redshift, Part 2
You can’t actually select from a table within a Redshift function. From the documentation: SQL_clauseA SQL SELECT clause.The SELECT clause can’t include any of.
Why I hate Redshift, part 1
I find so many reasons to hate Redshift that I’m going to start a series of notice. ERROR: Limit clause is not supported: (link).
Lateral Column Alias
Lateral column alias allows you to alias columns within a query and then use that same alias within the scope it was created. Basically.
Loading and Querying External Tables in Redshift
Did you know that you can use S3 to store data in parquet files, wire up an external table in Redshift to point to.
How is a SQL statement executed in the database?
Courtesy of Alex Xu The diagram below shows the process. Note that the architectures for different databases are different, the diagram demonstrates some common.
Split-Unnest in Redshift
I recently took a role in a startup to start building a solid data engineering foundation. For the past few years, the data engineering.
Deep Learning Specialization Review, Course One
I’ve been taking the Deep Learning Specialization on Coursera starting with Neural Networks and Deep Learning. This is a revamped specialization from the first.