| Nama Catalog | Deskripsi | Data Source | Extraction Query | Status | Aksi |
|---|---|---|---|---|---|
| Tagihan Listrik | Trino - Kemenkeu |
SELECT * FROM (WITH ranked_data AS ( SELECT …
|
Active | Edit - Hapus | |
| Data Mart Anggaran Rinci - Trino (2) | TRINO 2 | Trino - Kemenkeu |
SELECT * FROM hive.l0_fenom.dmart_anggaran_rinci
|
Active | Edit - Hapus |
| TEST QUERY HANA | SAP HANA | portal DB - Data |
select * from anggaran
|
Active | Edit - Hapus |
| TEST QUERY ORACLE | TEST QUERY ORACLE | FENOM_DB - Anggaran |
select * from dashboard
|
Active | Edit - Hapus |
| TESTBARU - FILTER | FILTER LEVEL 3,4,5, pemda | FENOM_DB - Anggaran |
select * from data_catalog
|
Active | Edit - Hapus |
| Test Data Query Baru | Test Data Query Baru | FENOM_DB - Anggaran |
select * from dashboard
|
Active | Edit - Hapus |
| Data Mart Realisasi Rinci - Trino | DataMart Realisasi Rinci - Trino Kemenkeu | Trino - Kemenkeu |
SELECT * FROM hive.l0_fenom.dmart_realisasi_rinci
|
Active | Edit - Hapus |
| Data Mart Anggaran Rinci - Trino | Data Mart Anggaran Rinci - Trino | Trino - Kemenkeu |
SELECT * FROM hive.l0_fenom.dmart_anggaran_rinci
|
Active | Edit - Hapus |
| Data Mart Realisasi Rinci | Data realisasi anggaran rinci per satker, SKPD, program, dan kegiatan | FENOM_DB - Anggaran |
SELECT * FROM anggaran.dmart_realisasi_rinci
|
Active | Edit - Hapus |
| Data Mart Anggaran Rinci | Data anggaran rinci per satker, SKPD, program, dan kegiatan | FENOM_DB - Anggaran |
SELECT kodesatker, kodepemda, namapemda, kodeskpd, namaskpd, fungsi, subfungsi, …
|
Active | Edit - Hapus |
| Data Pendidikan dan Kesehatan | Data statistik pendidikan dan kesehatan daerah untuk monitoring program | portal DB |
SELECT * FROM portal.role WHERE deleted_status = 0
|
Active | Edit - Hapus |
| Sample APBD Data | Data anggaran belanja daerah untuk testing catalog | portal DB - Data |
SELECT * FROM portal.dashboard WHERE deleted_status = 0
|
Active | Edit - Hapus |