... to my blog style space for easier contribution by third parties and to provide what I believe to be an easier reading experience. Please field all enquiries and issues to the source repository.
AbstractUmbra
/ 00-deprecation.md
Last active
July 14, 2024 16:01
discord.py 2.0+ slash command info and examples
malkavian-librarian
/ bq_date_dimension.sql
Created
April 21, 2020 20:13
— forked from richardsalt/bq_date_dimension.sql
Generate Date Dimension Table for BigQuery
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --Generate Date Dimension Table for BigQuery - adjust date range as required | |
| --this is a modified version of ewhauser/date_dim.sql gist | |
| SELECT | |
| d as id, | |
| FORMAT_DATE('%Y-%m', d) as yearMonth, | |
| FORMAT_DATE('%F', d) as yearMonthDay, | |
| EXTRACT(YEAR FROM d) AS year, | |
| EXTRACT(MONTH FROM d) AS month, | |
| FORMAT_DATE('%m', d) as monthPadded, | |
| EXTRACT(DAY FROM d) as day, |
Soheab
/ 0-discord.Colour.md
Last active
May 20, 2024 15:16
See everything related to discord.Colour in a clean way with their usages.