Live data from Hacker News

ELT your data with PlanetScale Connect

planetscale.com

1–10 of 21 posts

Re: ELT your data with PlanetScale Connect

#3
I thought the common denominator for this was (and has been, for decades) ETL? Extract, Transform, Load and in that order, because what other order would make sense?

Getting such basic things wrong doesn’t exactly give the reader the impression that the writer knows the subject particularly well.

Re: ELT your data with PlanetScale Connect

#4
post #3

I thought the common denominator for this was (and has been, for decades) ETL? Extract, Transform, Load and in that order, because what other order would make sense? Getting such basic things wrong doesn’t exactly give the reader the impression that the writer knows the subject particularly well.

ETL is the standard terminology that I learned, going back decades.

Re: ELT your data with PlanetScale Connect

#5
post #3

I thought the common denominator for this was (and has been, for decades) ETL? Extract, Transform, Load and in that order, because what other order would make sense? Getting such basic things wrong doesn’t exactly give the reader the impression that the writer knows the subject particularly well.

Its not a typo but describes a product difference. ELT is a common term for a new type of data eng workflow that isn't mapped to ETL. In most ELT products the raw data is loaded into and then transformed by the data warehouse tool. As opposed to the ETL pipelines many of us are used to where the data gets transformed in a separate process before being dropped into the DW.

Re: ELT your data with PlanetScale Connect

#6
post #3

I thought the common denominator for this was (and has been, for decades) ETL? Extract, Transform, Load and in that order, because what other order would make sense? Getting such basic things wrong doesn’t exactly give the reader the impression that the writer knows the subject particularly well.

They aren’t the only ones using ELT instead of ETL. I hear they are different but I have no motivation to even Wikipedia the topic to find out.

Re: ELT your data with PlanetScale Connect

#7
post #3

I thought the common denominator for this was (and has been, for decades) ETL? Extract, Transform, Load and in that order, because what other order would make sense? Getting such basic things wrong doesn’t exactly give the reader the impression that the writer knows the subject particularly well.

data warehouses are now processing engines that scale compute independently of storage. you can simply dump your raw data into warehouse and do your transform there. Hence ELT.

Re: ELT your data with PlanetScale Connect

#9
post #7
post #3

I thought the common denominator for this was (and has been, for decades) ETL? Extract, Transform, Load and in that order, because what other order would make sense? Getting such basic things wrong doesn’t exactly give the reader the impression that the writer knows the subject particularly well.

data warehouses are now processing engines that scale compute independently of storage. you can simply dump your raw data into warehouse and do your transform there. Hence ELT.

Using a data warehouse as a processing engine is one of the dumbest things to come out of the data world.

ELT is genius marketing though!

Post reply on HN