Skip to content

Instantly share code, notes, and snippets.

@sqlparser

sqlparser/gist:cfa2d028c8fc48554306f2a19e47345e

Created December 12, 2023 06:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sqlparser/cfa2d028c8fc48554306f2a19e47345e to your computer and use it in GitHub Desktop.
Save sqlparser/cfa2d028c8fc48554306f2a19e47345e to your computer and use it in GitHub Desktop.
Download ZIP
Amazon Athena Sample SQL
Raw
gistfile1.txt
```sql
SELECT DISTINCT regexp_extract("$path", '[^/]+$') AS data_source_file
FROM sampledb.elb_logs
ORDER By data_source_file ASC
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment