Skip to content

Instantly share code, notes, and snippets.

@takedasan
Created July 28, 2020 13:45
Show Gist options
  • Save takedasan/d1d3b897dd7e64638b128308b4b75341 to your computer and use it in GitHub Desktop.
Save takedasan/d1d3b897dd7e64638b128308b4b75341 to your computer and use it in GitHub Desktop.
snowflakeつかうと・・・?
<mxfile host="embed.diagrams.net" modified="2020-07-28T13:27:02.676Z" agent="5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.47.3 Chrome/78.0.3904.130 Electron/7.3.2 Safari/537.36" etag="Wid7gWhNb4vKBZUmwGyS" version="13.5.4" pages="2">
<diagram id="6hGFLwfOUW9BJ-s0fimq" name="Athena_1">
<mxGraphModel dx="1154" dy="796" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="0"/>
<mxCell id="1" parent="0"/>
<mxCell id="16" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="6" target="17">
<mxGeometry relative="1" as="geometry">
<mxPoint x="210" y="315" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="6" value="ログ&lt;br&gt;ファイル" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" parent="1" vertex="1">
<mxGeometry x="95" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="7" value="Tableau&lt;br&gt;レポート" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" parent="1" vertex="1">
<mxGeometry x="757" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="8" value="&lt;font color=&quot;#000000&quot;&gt;開発ユーザ&lt;/font&gt;" style="shape=umlActor;verticalLabelPosition=bottom;labelBackgroundColor=#ffffff;verticalAlign=top;html=1;outlineConnect=0;" parent="1" vertex="1">
<mxGeometry x="375" y="440" width="30" height="60" as="geometry"/>
</mxCell>
<mxCell id="15" value="" style="endArrow=classic;html=1;exitX=0.5;exitY=0;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" source="8" target="19" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="500" y="450" as="sourcePoint"/>
<mxPoint x="390" y="375" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="22" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="17" target="19">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="17" value="Amazon S3" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.s3;" vertex="1" parent="1">
<mxGeometry x="218" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="23" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="18" target="17">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="18" value="AWS Glue" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.glue;" vertex="1" parent="1">
<mxGeometry x="218" y="85" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="25" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="19" target="21">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="19" value="Amazon Athena" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.athena;" vertex="1" parent="1">
<mxGeometry x="350" y="260" width="80" height="110" as="geometry"/>
</mxCell>
<mxCell id="28" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="20" target="7">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="20" value="Amazon RDS" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.rds;" vertex="1" parent="1">
<mxGeometry x="620" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="26" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="21" target="20">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="21" value="AWS Batch" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.batch;" vertex="1" parent="1">
<mxGeometry x="483" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="24" value="データカタログ作成" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;" vertex="1" parent="1">
<mxGeometry x="260" y="210" width="120" height="20" as="geometry"/>
</mxCell>
<mxCell id="27" value="データの集約&lt;br&gt;データの切り出し" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;" vertex="1" parent="1">
<mxGeometry x="535" y="375" width="110" height="30" as="geometry"/>
</mxCell>
<mxCell id="29" value="任意条件での&lt;br&gt;手動エクスポート" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;" vertex="1" parent="1">
<mxGeometry x="275" y="395" width="110" height="30" as="geometry"/>
</mxCell>
</root>
</mxGraphModel>
</diagram>
<diagram name="Athena_2" id="mpdyPRulKow5-oR1rFUB">
<mxGraphModel dx="1154" dy="796" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="eocghYX4ELkkCu89i4D1-0"/>
<mxCell id="eocghYX4ELkkCu89i4D1-1" parent="eocghYX4ELkkCu89i4D1-0"/>
<mxCell id="eocghYX4ELkkCu89i4D1-2" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="eocghYX4ELkkCu89i4D1-1" source="eocghYX4ELkkCu89i4D1-3" target="eocghYX4ELkkCu89i4D1-8">
<mxGeometry relative="1" as="geometry">
<mxPoint x="210" y="315" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-3" value="ログ&lt;br&gt;ファイル" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="95" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-4" value="Tableau&lt;br&gt;レポート" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="530" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-7" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="eocghYX4ELkkCu89i4D1-1" source="eocghYX4ELkkCu89i4D1-8" target="eocghYX4ELkkCu89i4D1-20">
<mxGeometry relative="1" as="geometry">
<mxPoint x="350" y="315" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-8" value="Amazon S3" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.s3;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="218" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-13" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="eocghYX4ELkkCu89i4D1-1" source="eocghYX4ELkkCu89i4D1-20" target="eocghYX4ELkkCu89i4D1-4">
<mxGeometry relative="1" as="geometry">
<mxPoint x="700" y="315" as="sourcePoint"/>
</mxGeometry>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-20" value="Snowflake&lt;br&gt;(Snowpipeでの&lt;br&gt;ロード)" style="rounded=0;whiteSpace=wrap;html=1;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="354" y="285" width="120" height="60" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-21" value="S3にファイルを置けばよい世界・・・" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="230" y="390" width="222" height="20" as="geometry"/>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>
<mxfile host="embed.diagrams.net" modified="2020-07-28T13:27:02.676Z" agent="5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.47.3 Chrome/78.0.3904.130 Electron/7.3.2 Safari/537.36" etag="Wid7gWhNb4vKBZUmwGyS" version="13.5.4" pages="2">
<diagram id="6hGFLwfOUW9BJ-s0fimq" name="Athena_1">
<mxGraphModel dx="1154" dy="796" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="0"/>
<mxCell id="1" parent="0"/>
<mxCell id="16" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="6" target="17">
<mxGeometry relative="1" as="geometry">
<mxPoint x="210" y="315" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="6" value="ログ&lt;br&gt;ファイル" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" parent="1" vertex="1">
<mxGeometry x="95" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="7" value="Tableau&lt;br&gt;レポート" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" parent="1" vertex="1">
<mxGeometry x="757" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="8" value="&lt;font color=&quot;#000000&quot;&gt;開発ユーザ&lt;/font&gt;" style="shape=umlActor;verticalLabelPosition=bottom;labelBackgroundColor=#ffffff;verticalAlign=top;html=1;outlineConnect=0;" parent="1" vertex="1">
<mxGeometry x="375" y="440" width="30" height="60" as="geometry"/>
</mxCell>
<mxCell id="15" value="" style="endArrow=classic;html=1;exitX=0.5;exitY=0;exitDx=0;exitDy=0;exitPerimeter=0;" parent="1" source="8" target="19" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="500" y="450" as="sourcePoint"/>
<mxPoint x="390" y="375" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="22" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="17" target="19">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="17" value="Amazon S3" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.s3;" vertex="1" parent="1">
<mxGeometry x="218" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="23" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="18" target="17">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="18" value="AWS Glue" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.glue;" vertex="1" parent="1">
<mxGeometry x="218" y="85" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="25" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="19" target="21">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="19" value="Amazon Athena" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.athena;" vertex="1" parent="1">
<mxGeometry x="350" y="260" width="80" height="110" as="geometry"/>
</mxCell>
<mxCell id="28" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="20" target="7">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="20" value="Amazon RDS" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.rds;" vertex="1" parent="1">
<mxGeometry x="620" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="26" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="1" source="21" target="20">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="21" value="AWS Batch" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.batch;" vertex="1" parent="1">
<mxGeometry x="483" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="24" value="データカタログ作成" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;" vertex="1" parent="1">
<mxGeometry x="260" y="210" width="120" height="20" as="geometry"/>
</mxCell>
<mxCell id="27" value="データの集約&lt;br&gt;データの切り出し" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;" vertex="1" parent="1">
<mxGeometry x="535" y="375" width="110" height="30" as="geometry"/>
</mxCell>
<mxCell id="29" value="任意条件での&lt;br&gt;手動エクスポート" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;" vertex="1" parent="1">
<mxGeometry x="275" y="395" width="110" height="30" as="geometry"/>
</mxCell>
</root>
</mxGraphModel>
</diagram>
<diagram name="Athena_2" id="mpdyPRulKow5-oR1rFUB">
<mxGraphModel dx="1154" dy="796" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="eocghYX4ELkkCu89i4D1-0"/>
<mxCell id="eocghYX4ELkkCu89i4D1-1" parent="eocghYX4ELkkCu89i4D1-0"/>
<mxCell id="eocghYX4ELkkCu89i4D1-2" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;" edge="1" parent="eocghYX4ELkkCu89i4D1-1" source="eocghYX4ELkkCu89i4D1-3" target="eocghYX4ELkkCu89i4D1-8">
<mxGeometry relative="1" as="geometry">
<mxPoint x="210" y="315" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-3" value="ログ&lt;br&gt;ファイル" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="95" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-4" value="Tableau&lt;br&gt;レポート" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=22;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="530" y="275" width="64" height="80" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-7" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="eocghYX4ELkkCu89i4D1-1" source="eocghYX4ELkkCu89i4D1-8" target="eocghYX4ELkkCu89i4D1-20">
<mxGeometry relative="1" as="geometry">
<mxPoint x="350" y="315" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-8" value="Amazon S3" style="outlineConnect=0;fontColor=#232F3E;gradientColor=none;strokeColor=#ffffff;fillColor=#232F3E;dashed=0;verticalLabelPosition=middle;verticalAlign=bottom;align=center;html=1;whiteSpace=wrap;fontSize=10;fontStyle=1;spacing=3;shape=mxgraph.aws4.productIcon;prIcon=mxgraph.aws4.s3;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="218" y="265" width="80" height="100" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-13" value="" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="eocghYX4ELkkCu89i4D1-1" source="eocghYX4ELkkCu89i4D1-20" target="eocghYX4ELkkCu89i4D1-4">
<mxGeometry relative="1" as="geometry">
<mxPoint x="700" y="315" as="sourcePoint"/>
</mxGeometry>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-20" value="Snowflake&lt;br&gt;(Snowpipeでの&lt;br&gt;ロード)" style="rounded=0;whiteSpace=wrap;html=1;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="354" y="285" width="120" height="60" as="geometry"/>
</mxCell>
<mxCell id="eocghYX4ELkkCu89i4D1-21" value="S3にファイルを置けばよい世界・・・" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="eocghYX4ELkkCu89i4D1-1">
<mxGeometry x="230" y="390" width="222" height="20" as="geometry"/>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment