Created
May 7, 2022 12:51
-
-
Save h3xagn/72c5d30cadb26f842f8c129fd5408eb6 to your computer and use it in GitHub Desktop.
Build ETL from device to cloud: https://h3xagn.com
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
| //one time export of dimension tables | |
| .export async to table dimSiteEqmt <| meta_site_eqmt | |
| .export async to table dimSystemTag <| meta_system_tag | |
| //continuous export of data | |
| .create-or-alter continuous-export ParquetExport over (raw_oil_data) to table factOilData | |
| with | |
| (intervalBetweenRuns=1h, sizeLimit=104857600) | |
| <| raw_oil_data | |
| | parse TagName with Site: string '.' System: string '.' EqmtIp: string '.' Tag: string |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment