Fidocia Wima Adityawarman adityawarmanfw
adityawarmanfw
/ duckdb_generate_pivot_query.sql
Last active
January 30, 2023 20:42
DuckDB SQL query to generate SQL query to pivot data from rows into columns.
This file contains hidden or 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
| WITH gen_series AS ( | |
| SELECT | |
| i, | |
| count(*) over () as rows | |
| FROM generate_series(1,100000) tbl(i) | |
| ), gen_year AS ( | |
| SELECT | |
| i, | |
| CASE WHEN i <= rows * 0.25 THEN 2022 | |
| WHEN i <= rows * 0.5 THEN 2023 |
adityawarmanfw
/ ansible-test.json
Last active
June 27, 2024 08:18
This file contains hidden or 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
| [ | |
| { | |
| "_ansible_facts_gathered": true, | |
| "ansible_all_ipv4_addresses": [ | |
| "10.20.5.204" | |
| ], | |
| "ansible_all_ipv6_addresses": [ | |
| "2a00:6020:41e1:fea0:a00:27ff:fee0:63ba", | |
| "2a00:6020:41e1:fe85:5:f9db:2e3f:1e85", | |
| "2a00:6020:41e1:fe85:a00:27ff:fee0:63ba", |
adityawarmanfw
/ tokopedia_order_sample.json
Created
July 3, 2024 10:44
This file contains hidden or 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
| { | |
| "header": { | |
| "process_time": 0.018328845, | |
| "messages": "Your request has been processed successfully" | |
| }, | |
| "data": [ | |
| { | |
| "fs_id": "13004", | |
| "order_id": 43481289, | |
| "is_cod_mitra": false, |
OlderNewer