Split Large Queries in Athena with a Simple Modulo Trick
Learn how you might balance the load in Amazon Athena when you have large partition windows.
2026-10-05
1,694 reads
Learn how you might balance the load in Amazon Athena when you have large partition windows.
2026-10-05
1,694 reads
Learn the basics of Apache Druid and how it can be used to ingest data into a data lake.
2023-11-10
14,734 reads
This article discusses different approaches of Upserts (update+inserts) in Amazon Redshift
2023-08-09
30,571 reads
This article gives an overview of Amazon Redshift, the cloud data warehouse in AWS.
2023-07-24
25,758 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...
Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah 52663
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers