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
# https://github.com/bricaud/graphexp/archive/v0.8.0.zip | |
# | |
# Copyright IBM Corp All Rights Reserved | |
# | |
# SPDX-License-Identifier: Apache-2.0 | |
# | |
version: "3" | |
services: | |
graphexp: |
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
FROM nginx:stable | |
LABEL maintainer="[email protected]" | |
ENV http_proxy $http_proxy | |
ENV https_proxy $https_proxy | |
ENV no_proxy $no_proxy | |
ENV PATH /usr/local/bin:$PATH | |
ENV GRAPHEXP_SOURCE_URL $GRAPHEXP_SOURCE_URL |
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
[ | |
{ | |
"ParameterKey": "Env", | |
"ParameterValue": "test" | |
}, | |
{ | |
"ParameterKey": "AppName", | |
"ParameterValue": "neptune-data-pipeline-graph" | |
}, | |
{ |
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
# /* | |
# * Copyright 2018 Amazon.com, Inc. or its affiliates. All Rights Reserved. | |
# * | |
# * Permission is hereby granted, free of charge, to any person obtaining a copy of this | |
# * software and associated documentation files (the "Software"), to deal in the Software | |
# * without restriction, including without limitation the rights to use, copy, modify, | |
# * merge, publish, distribute, sublicense, and/or sell copies of the Software, and to | |
# * permit persons to whom the Software is furnished to do so. | |
# * | |
# * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, |
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
avro | |
confluent-kafka[avro,json] | |
pendulum | |
psycopg2-binary | |
pymysql | |
sqlalchemy |
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
# install serverless | |
npm install -g serverless | |
# creating serverless project | |
serverless create \ | |
--template aws-python3 \ | |
--name serverless-etl-sap-tms \ | |
--path serverless-etl-sap-tms |
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
{ | |
"type": "object", | |
"title": "MyTopic", | |
"properties": { | |
"o_id": {"type": ["number", "null"], "multipleOf": 1.0}, | |
"o_sap_ts": {"type": ["string", "null"]}, | |
"o_so_key": {"type": ["string", "null"]}, | |
"o_ordertypecode": {"type": ["string", "null"]}, | |
"o_salesorderno": {"type": ["string", "null"]}, | |
"o_salesofficecode": {"type": ["string", "null"]}, |
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
SELECT * FROM my_table; |
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
SELECT * FROM table_name |
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
SELECT | |
do_no, | |
SUM(amount) AS amount_agg, | |
SUM(selling_amount) AS selling_amount_agg, | |
SUM(discount_amount) AS discount_amount_agg | |
FROM order_billing | |
GROUP BY | |
do_no |