-
Notifications
You must be signed in to change notification settings - Fork 0
/
accelerometer_landing_to_trusted.py
80 lines (73 loc) · 2.37 KB
/
accelerometer_landing_to_trusted.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
import sys
from awsglue.transforms import *
from awsglue.utils import getResolvedOptions
from pyspark.context import SparkContext
from awsglue.context import GlueContext
from awsglue.job import Job
args = getResolvedOptions(sys.argv, ["JOB_NAME"])
sc = SparkContext()
glueContext = GlueContext(sc)
spark = glueContext.spark_session
job = Job(glueContext)
job.init(args["JOB_NAME"], args)
# Script generated for node Landing Accelerometer data
LandingAccelerometerdata_node1684513388030 = (
glueContext.create_dynamic_frame.from_options(
format_options={"multiline": False},
connection_type="s3",
format="json",
connection_options={
"paths": ["s3://stedi-lakehouse/project/accelerometer/landing/"],
"recurse": True,
},
transformation_ctx="LandingAccelerometerdata_node1684513388030",
)
)
# Script generated for node Customer Trusted Zone
CustomerTrustedZone_node1 = glueContext.create_dynamic_frame.from_options(
format_options={"multiline": False},
connection_type="s3",
format="json",
connection_options={
"paths": ["s3://stedi-lakehouse/project/customer/trusted/"],
"recurse": True,
},
transformation_ctx="CustomerTrustedZone_node1",
)
# Script generated for node Join Customer
JoinCustomer_node1684513375647 = Join.apply(
frame1=LandingAccelerometerdata_node1684513388030,
frame2=CustomerTrustedZone_node1,
keys1=["user"],
keys2=["email"],
transformation_ctx="JoinCustomer_node1684513375647",
)
# Script generated for node Drop Fields
DropFields_node1684513639194 = DropFields.apply(
frame=JoinCustomer_node1684513375647,
paths=[
"serialNumber",
"shareWithPublicAsOfDate",
"birthday",
"registrationDate",
"shareWithResearchAsOfDate",
"customerName",
"lastUpdateDate",
"email",
"phone",
"shareWithFriendsAsOfDate",
],
transformation_ctx="DropFields_node1684513639194",
)
# Script generated for node Trusted Accelerometer
TrustedAccelerometer_node3 = glueContext.write_dynamic_frame.from_options(
frame=DropFields_node1684513639194,
connection_type="s3",
format="json",
connection_options={
"path": "s3://stedi-lakehouse/project/accelerometer/trusted/",
"partitionKeys": [],
},
transformation_ctx="TrustedAccelerometer_node3",
)
job.commit()