Parking Space - Data Modelling

Parking Space - Data Modelling

Arabinda Mohapatra Arabinda Mohapatra

Arabinda Mohapatra

Pyspark, SnowFlake,AWS, Stored Procedure, Hadoop,Python,SQL,Airflow,Kakfa,IceBerg,DeltaLake,HIVE,BFSI,Telecom

发布日期: 2024年9月23日
+ 关注

Designing a Data Model for Parking Space

Fact_Parking_Transaction (Center Fact Table)

  • Transaction_ID (PK)
  • DateTime_ID (FK) -> Connects to Dim_DateTime
  • Vehicle_ID (FK) -> Connects to Dim_Vehicle
  • Location_ID (FK) -> Connects to Dim_Parking_Location
  • Entry_Time_ID (FK) -> Connects to Dim_Time
  • Exit_Time_ID (FK) -> Connects to Dim_Time
  • Parking_Type_ID (FK) -> Connects to Dim_Parking_Type
  • Rate_ID (FK) -> Connects to Dim_Rate

?? Dim_DateTime (Dimension Table)

  • DateTime_ID (PK)
  • Full_DateTime, Date, Time, Day, Month, Year, Hour, Minute, Second

?? Dim_Vehicle (Dimension Table)

  • Vehicle_ID (PK)
  • Vehicle_Type, Vehicle_Make, Vehicle_Model, License_Plate, Owner_Name, Contact_Number, Owner_Address

?? Dim_Parking_Location (Dimension Table)

  • Location_ID (PK)
  • Location_Name, Location_Type, City, State, Zip_Code

?? Dim_Parking_Type (Dimension Table)

  • Parking_Type_ID (PK)
  • Parking_Type_Description

?? Dim_Rate (Dimension Table)

  • Rate_ID (PK)
  • Vehicle_Type, Parking_Location_ID (FK), Hourly_Rate

要查看或添加评论，请登录

Arabinda Mohapatra的更多文章

  • Deep Dive into Snowflake: Analyzing Storage and Credit Consumption
    2025年2月24日

    Deep Dive into Snowflake: Analyzing Storage and Credit Consumption

    1. Table Storage Metrics select TABLE_SCHEMA,TABLE_CATALOG AS"DB",TABLE_SCHEMA, TABLE_NAME,sum(ACTIVE_BYTES) +…

    1 条评论
  • Continuous Data Ingestion Using Snowpipe in Snowflake for Amazon S3
    2025年2月23日

    Continuous Data Ingestion Using Snowpipe in Snowflake for Amazon S3

    USE WAREHOUSE LRN; USE DATABASE LRN_DB; USE SCHEMA LEARNING; ---Create a Table in snowflake as per the source data…

    1 条评论
  • Data Loading with Snowflake's COPY INTO Command-Table
    2025年2月18日

    Data Loading with Snowflake's COPY INTO Command-Table

    Snowflake's COPY INTO command is a powerful tool for data professionals, streamlining the process of loading data from…

  • SNOW-SQL in SNOWFLAKE
    2025年2月17日

    SNOW-SQL in SNOWFLAKE

    SnowSQL is a command-line tool designed by Snowflake to interact with Snowflake databases. It allows users to execute…

  • Stages in Snowflake
    2025年2月9日

    Stages in Snowflake

    Stages in Snowflake play a crucial role in data loading and unloading processes. They serve as intermediary storage…

  • Snowflake Tips
    2025年2月8日

    Snowflake Tips

    ??Tip 1: Use the USE statement to switch between warehouses Instead of specifying the warehouse name in every query…

  • SnowFlake
    2025年2月8日

    SnowFlake

    ??What is a Virtual Warehouse in Snowflake? ??A Virtual Warehouse in Snowflake is a cluster of compute resources that…

  • Snowflake Architecture
    2025年1月15日

    Snowflake Architecture

    https://airbyte.com/data-engineering-resources/snowflake-features ?? Snowflake: Merging the Best of Shared-Disk and…

  • All About dbt (Data Build Tool) with BigQuery ??
    2025年1月10日

    All About dbt (Data Build Tool) with BigQuery ??

    What is dbt? dbt is the T in ELT (Extract, Load, Transform). It allows you to write SQL queries that transform raw data…

  • DLT Append Flow(Union) & Autoloader | Pass parameter in DLT pipeline |Generate tables dynamically
    2025年1月7日

    DLT Append Flow(Union) & Autoloader | Pass parameter in DLT pipeline |Generate tables dynamically

    Create a folder and then create two workflows DLT PIPELINE FOLDER WORKFLOWS Streaming Tables: orders_autoloaders_bronze…

社区洞察

其他会员也浏览了