Skip to content

Uploading tables to Azure Blob Storage

Simeon Kakpovi edited this page Sep 24, 2022 · 11 revisions

You can generate a shared access token for Azure blob storage

image

Then run the following command to export your tables to Azure blob storage. These can be reimported by other later.

.export
  async compressed
  to csv (
    h@"https://storage1.blob.core.windows.net/containerName;secretKey""
  ) with (
    namePrefix="Email",
    includeHeaders="all",
    encoding ="UTF8NoBOM"
  )
  <| Email


.export
  async compressed
  to csv (
    h@"https://storage1.blob.core.windows.net/containerName;secretKey""
  ) with (
    namePrefix="Employees",
    includeHeaders="all",
    encoding ="UTF8NoBOM"
  )
  <| Employees


  .export
  async compressed
  to csv (
    h@"https://storage1.blob.core.windows.net/containerName;secretKey""
  ) with (
    namePrefix="FileCreationEvents",
    includeHeaders="all",
    encoding ="UTF8NoBOM"
  )
  <| FileCreationEvents

  .export
  async compressed
  to csv (
    h@"https://storage1.blob.core.windows.net/containerName;secretKey""
  ) with (
    namePrefix="OutboundBrowsing",
    includeHeaders="all",
    encoding ="UTF8NoBOM"
  )
  <| OutboundBrowsing


  .export
  async compressed
  to csv (
    h@"https://storage1.blob.core.windows.net/containerName;secretKey""
  ) with (
    namePrefix="PassiveDns",
    includeHeaders="all",
    encoding ="UTF8NoBOM"
  )
  <| PassiveDns



.show operation aeccb322-9bd4-451c-b078-75dae97ad626 details```