Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sequence_diagram: Note placed outside of group #856

Closed
alixander opened this issue Feb 20, 2023 · 0 comments · Fixed by #867
Closed

sequence_diagram: Note placed outside of group #856

alixander opened this issue Feb 20, 2023 · 0 comments · Fixed by #867

Comments

@alixander
Copy link
Collaborator

https://play.d2lang.com/?script=jFTRbtowFH3nK67y0lYCRkufom4SWvswia2T0k57QLI850K8Onbq64yiqv8-OSYhpAH6gGTjc07uuT7XZGQMrwOAqugYCJ9L1AJZKvnK8nwAIKzRMbxuAUJaofBtABChU6ywRmBaWhwXm8j_SdqsC1k0-7sXZ7lw7MFyTUtjczY3PK1PE5Fhztk37U-4v_T65EHmyBK0EqmR3pDDfLsLmwFAos16qfgT-vV04IGT6_hqMry8jK8mUXAXXMDoS0_V3rROISKukFiVLyYd5sQc_6OQoor_njeOwvlCn18N4axN52lqkejsYrjQ59POIWWyKKReMcGVKFXlOiCvO0hfxdnF4e-vucXMlIRM8xwXeqGT2fwuYfP72e1HWH4QPOt38n02nx9iVF1rX2sMwfgQ9gto77100GszvVRzXzHw9G9JbseC2ePDPUsek593P27BGZhOJkAojE7ppBgJrrCltWuFVwoW-0WOZHRrtes06ChjCnCZNeUqA-QiC-AmckfTP47IceuYkznCZ0i5Q78cNwtt1hGc1qkM9I9RDN0whQJr0X5WJdiZvhgoM8UQhEX_ojPuao0OMGSlmdPYjx0RE8qUKRMmL7iVZHTN3iE9MexiyPkLkymjZ8WeS7SbHvTNqEErs0ZyrLAy53bDnvAEPpOr7DSh6yMt83zD5DaHB0tviR6sfT-21j-45IDqvw585Ga0z3Kl1SdJrcqWpVLHWjqOHgkpwKqUBCAs9NKaHN5nJdpqBIl3DQvrrVS6_ECLgzJbSlQ7M9183Yz2SXUj-r_Wk85k6sfiH8LX5Bccw7VeFm3WVesKU_j3uh6gBlJdzjT2Q8w_dWduAPBW_d4G_wMAAP__&

soi: {
  shape: sequence_diagram
  cron: {shape: circle}
  "etl_procedure.py"
  "snowpipe.py"
  "Extract_Transform_Load.py"
  "Schema_Information.py"
  "Time_Series.py"
  "system.py"
  system
  Snowflake
  S3

  "04:20,11:20": {
    cron -> "etl_procedure.py": send "sales_order_items_tables"
    "etl_procedure.py"."tables\n(2, 'sales_order_address'),\n(3, 'sales_order_shipping_calculation'),\n(4, 'sales_order_item')"
    "etl_procedure.py"."warehouse_name\n\nSALES_LOAD"
    "etl_procedure.py"."warehouse_size\n\nXSMALL"
    "etl_procedure.py" -> "snowpipe.py": tables, warehouse_name, warehouse_size
    "snowpipe.py" -> Snowflake: adjust warehouse AUTO_SUSPEND to 300 seconds
    "snowpipe.py" -> Snowflake: scale warehouse SALES_LOAD to XSMALL
    "snowpipe.py" -> "Extract_Transform_Load.py": table, warehouse_name
    "loop through each table": {
      "Extract_Transform_Load.py"."start_time = datetime.datetime.now"
      "Extract_Transform_Load.py" -> "Schema_Information.py": sales_order_item table
      "Schema_Information.py" -> "Time_Series.py": shop, created_at
      "Time_Series.py" -> "system.py": cross_cloud_comparison
      "system.py" -> system: max_id_sql_query
      "system.py" <- system: lowest_primary_key
      "system.py" <- system: highest_primary_key
      "system.py" -> "system.py": dummy_ids
      "system.py" -> system: primary_key_query
      "system.py" -> Snowflake: request snowflake_ids
      "system.py" <- Snowflake: return snowflake_ids
      "system.py" -> system: full_sql_query
      "system.py"."Uses full_table_query \nfrom Schema_Information"
      system -> "system.py": system_table_df
      "system.py" -> "system.py": format_fields
      "Time_Series.py" <- "system.py": return system_table_df
      "Time_Series.py" -> S3: save CSV
      "Time_Series.py" -> Snowflake: snow_sql_populate
      Snowflake <- S3: data/sales_order_item
    }
  }
}

fsdew

This was referenced Feb 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Done
Development

Successfully merging a pull request may close this issue.

1 participant