Granting Alter Table in Redshift
OnOkay, I will admit. I have been dealing w/ Redshift and all of its “isms” over the past several months and it is relatively.
Read MoreAirflow Hate
OnAirflow is quickly working its way up the ranks on the list of things I hate. Just trying to get a monthly job to.
Read MoreWhy I Hate Redshift, Part 2
OnYou 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.
Read MoreWhy I hate Redshift, part 1
OnI find so many reasons to hate Redshift that I’m going to start a series of notice. ERROR: Limit clause is not supported: (link).
Read MoreLateral Column Alias
OnLateral column alias allows you to alias columns within a query and then use that same alias within the scope it was created. Basically.
Read MoreLoading and Querying External Tables in Redshift
OnDid you know that you can use S3 to store data in parquet files, wire up an external table in Redshift to point to.
Read MoreHow is a SQL statement executed in the database?
OnCourtesy of Alex Xu The diagram below shows the process. Note that the architectures for different databases are different, the diagram demonstrates some common.
Read MoreSplit-Unnest in Redshift
OnI recently took a role in a startup to start building a solid data engineering foundation. For the past few years, the data engineering.
Read MoreDeep Learning Specialization Review, Course One
OnI’ve been taking the Deep Learning Specialization on Coursera starting with Neural Networks and Deep Learning. This is a revamped specialization from the first.
Read More