🚀

Microsoft FabricのDatawarehouseを使ってみる-①

takekawa tomoki

2024/02/17に公開

やること

MicrosoftのDatawarehuoseを使ってみる

Datawarehouseとは？

前提

Azure Data Lake Storage Gen2を構築済みであること
コンテナーに下記のJSONファイル(test.json)がアップロード済みであること

[
    {"id": 1, "name": "John", "age": 30, "city": "New York"},
    {"id": 2, "name": "Jane", "age": 25, "city": "Chicago"},
    {"id": 3, "name": "Bob", "age": 32, "city": "San Francisco"},
    {"id": 4, "name": "Alice", "age": 29, "city": "Los Angeles"},
    {"id": 5, "name": "Tom", "age": 35, "city": "Houston"},
    {"id": 6, "name": "Jerry", "age": 28, "city": "Phoenix"},
    {"id": 7, "name": "Kim", "age": 24, "city": "Dallas"},
    {"id": 8, "name": "Emily", "age": 31, "city": "Austin"},
    {"id": 9, "name": "Sophie", "age": 27, "city": "Jacksonville"},
    {"id": 10, "name": "Brian", "age": 36, "city": "Indianapolis"},
    {"id": 11, "name": "Nathan", "age": 22, "city": "Columbus"},
    {"id": 12, "name": "Claire", "age": 34, "city": "Charlotte"},
    {"id": 13, "name": "David", "age": 33, "city": "Seattle"},
    {"id": 14, "name": "Grace", "age": 26, "city": "Denver"},
    {"id": 15, "name": "Anthony", "age": 37, "city": "Boston"},
    {"id": 16, "name": "Rebecca", "age": 23, "city": "Nashville"},
    {"id": 17, "name": "Vincent", "age": 38, "city": "Detroit"},
    {"id": 18, "name": "Isabella", "age": 21, "city": "Las Vegas"},
    {"id": 19, "name": "Albert", "age": 40, "city": "Portland"},
    {"id": 20, "name": "Olivia", "age": 39, "city": "Baltimore"}
]