Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/influxdb3/cloud-serverless/reference/sample-data.md

18 KiB
Raw Permalink Blame History

title description menu weight
Sample data Sample datasets are used throughout the the InfluxDB Cloud Serverless documentation to demonstrate functionality. Use the following sample datasets to replicate provided examples.
influxdb3_cloud_serverless
name parent
Sample data Reference
110

Sample datasets are used throughout the {{< product-name >}} documentation to demonstrate functionality. Use the following sample datasets to replicate provided examples.

Get started home sensor data

Includes hourly home sensor data used in the Get started with {{< product-name >}} guide. This dataset includes anomalous sensor readings and helps to demonstrate processing and alerting on time series data. To customize timestamps in the dataset, use the {{< icon "clock" >}} button in the lower right corner of the page. This lets you modify the sample dataset to stay within the retention period of the bucket you write it to.

Time Range

{{% influxdb/custom-timestamps-span %}}2022-01-01T08:00:00Z{{% /influxdb/custom-timestamps-span %}} to {{% influxdb/custom-timestamps-span %}}2022-01-01T20:00:00Z{{% /influxdb/custom-timestamps-span %}} (Customizable)

Schema
  • home (measurement)
    • tags:
      • room
        • Kitchen
        • Living Room
    • fields:
      • co (integer)
      • temp (float)
      • hum (float)

{{< expand-wrapper >}} {{% expand "Write home sensor data to InfluxDB" %}}

Write the home sensor data to InfluxDB

Use the InfluxDB v2 or v1 API to write the Get started home sensor sample data to {{< product-name >}}.

{{< code-tabs-wrapper >}} {{% code-tabs %}} v2 API v1 API {{% /code-tabs %}} {{% code-tab-content %}}

{{% influxdb/custom-timestamps %}} {{% code-placeholders "API_TOKEN|BUCKET_NAME" "magenta" %}}

curl --request POST \
  https://{{< influxdb/host >}}/api/v2/write?bucket=BUCKET_NAME&precision=s \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary "
home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200
"

{{% /code-placeholders %}} {{% /influxdb/custom-timestamps %}}

{{% /code-tab-content %}} {{% code-tab-content %}}

{{% influxdb/custom-timestamps %}} {{% code-placeholders "API_TOKEN|BUCKET_NAME" "magenta" %}}

curl --request POST \
  https://{{< influxdb/host >}}/write?db=BUCKET_NAME&precision=s \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary "
home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1641024000
home,room=Kitchen temp=21.0,hum=35.9,co=0i 1641024000
home,room=Living\ Room temp=21.4,hum=35.9,co=0i 1641027600
home,room=Kitchen temp=23.0,hum=36.2,co=0i 1641027600
home,room=Living\ Room temp=21.8,hum=36.0,co=0i 1641031200
home,room=Kitchen temp=22.7,hum=36.1,co=0i 1641031200
home,room=Living\ Room temp=22.2,hum=36.0,co=0i 1641034800
home,room=Kitchen temp=22.4,hum=36.0,co=0i 1641034800
home,room=Living\ Room temp=22.2,hum=35.9,co=0i 1641038400
home,room=Kitchen temp=22.5,hum=36.0,co=0i 1641038400
home,room=Living\ Room temp=22.4,hum=36.0,co=0i 1641042000
home,room=Kitchen temp=22.8,hum=36.5,co=1i 1641042000
home,room=Living\ Room temp=22.3,hum=36.1,co=0i 1641045600
home,room=Kitchen temp=22.8,hum=36.3,co=1i 1641045600
home,room=Living\ Room temp=22.3,hum=36.1,co=1i 1641049200
home,room=Kitchen temp=22.7,hum=36.2,co=3i 1641049200
home,room=Living\ Room temp=22.4,hum=36.0,co=4i 1641052800
home,room=Kitchen temp=22.4,hum=36.0,co=7i 1641052800
home,room=Living\ Room temp=22.6,hum=35.9,co=5i 1641056400
home,room=Kitchen temp=22.7,hum=36.0,co=9i 1641056400
home,room=Living\ Room temp=22.8,hum=36.2,co=9i 1641060000
home,room=Kitchen temp=23.3,hum=36.9,co=18i 1641060000
home,room=Living\ Room temp=22.5,hum=36.3,co=14i 1641063600
home,room=Kitchen temp=23.1,hum=36.6,co=22i 1641063600
home,room=Living\ Room temp=22.2,hum=36.4,co=17i 1641067200
home,room=Kitchen temp=22.7,hum=36.5,co=26i 1641067200
"

{{% /code-placeholders %}} {{% /influxdb/custom-timestamps %}}

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Replace the following in the sample script:

  • {{% code-placeholder-key %}}BUCKET_NAME{{% /code-placeholder-key %}}: your InfluxDB Cloud Serverless bucket
  • {{% code-placeholder-key %}}API_TOKEN{{% /code-placeholder-key %}}: an API token with write pe mission to the bucket

{{% /expand %}} {{< /expand-wrapper >}}

Home sensor actions data

Includes hypothetical actions triggered by data in the Get started home sensor data and is a companion dataset to that sample dataset. To customize timestamps in the dataset, use the {{< icon "clock" >}} button in the lower right corner of the page. This lets you modify the sample dataset to stay within the retention period of the database you write it to.

Time Range

{{% influxdb/custom-timestamps-span %}}2022-01-01T08:00:00Z{{% /influxdb/custom-timestamps-span %}} to {{% influxdb/custom-timestamps-span %}}2022-01-01T20:00:00Z{{% /influxdb/custom-timestamps-span %}} (Customizable)

Schema
  • home_actions (measurement)
    • tags:
      • room
        • Kitchen
        • Living Room
      • action
        • alert
        • cool
      • level
        • ok
        • warn
    • fields:
      • description (string)

{{< expand-wrapper >}} {{% expand "Write home sensor actions data to InfluxDB" %}}

Write the home sensor actions data to InfluxDB

Use the InfluxDB v2 or v1 API to write the home sensor actions sample data to {{< product-name >}}.

{{< code-tabs-wrapper >}} {{% code-tabs %}} v2 API v1 API {{% /code-tabs %}} {{% code-tab-content %}}

{{% influxdb/custom-timestamps %}} {{% code-placeholders "API_TOKEN|BUCKET_NAME" %}}

curl --request POST \
  https://{{< influxdb/host >}}/api/v2/write?bucket=BUCKET_NAME&precision=s \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary '
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23°C). Cooling to 22°C." 1641027600
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.3°C). Cooling to 22°C." 1641060000
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.1°C). Cooling to 22°C." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 18 ppm." 1641060000
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 22 ppm." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 26 ppm." 1641067200
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 14 ppm." 1641063600
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 17 ppm." 1641067200
'

{{% /code-placeholders %}} {{% /influxdb/custom-timestamps %}}

{{% /code-tab-content %}} {{% code-tab-content %}}

{{% influxdb/custom-timestamps %}} {{% code-placeholders "API_TOKEN|BUCKET_NAME" %}}

curl --request POST \
  https://{{< influxdb/host >}}/write?db=BUCKET_NAME&precision=s \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary '
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23°C). Cooling to 22°C." 1641027600
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.3°C). Cooling to 22°C." 1641060000
home_actions,room=Kitchen,action=cool,level=ok description="Temperature at or above 23°C (23.1°C). Cooling to 22°C." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 18 ppm." 1641060000
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 22 ppm." 1641063600
home_actions,room=Kitchen,action=alert,level=warn description="Carbon monoxide level above normal: 26 ppm." 1641067200
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 14 ppm." 1641063600
home_actions,room=Living\ Room,action=alert,level=warn description="Carbon monoxide level above normal: 17 ppm." 1641067200
'

{{% /code-placeholders %}} {{% /influxdb/custom-timestamps %}}

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Replace the following in the sample script:

  • {{% code-placeholder-key %}}BUCKET_NAME{{% /code-placeholder-key %}}: your InfluxDB Cloud Serverless bucket
  • {{% code-placeholder-key %}}API_TOKEN{{% /code-placeholder-key %}}: a database token with write permission to the database

{{% /expand %}} {{< /expand-wrapper >}}

NOAA Bay Area weather data

Includes daily weather metrics from three San Francisco Bay Area airports from January 1, 2020 to December 31, 2022. This sample dataset includes seasonal trends and is good for exploring time series use cases that involve seasonality.

Time Range

2020-01-01T00:00:00Z to 2022-12-31T00:00:00Z

Schema
  • weather (measurement)
    • tags:
      • location
        • Concord
        • Hayward
        • San Francisco
    • fields
      • precip (float)
      • temp_avg (float)
      • temp_max (float)
      • temp_min (float)
      • wind_avg (float)

{{< expand-wrapper >}} {{% expand "Write the NOAA Bay Area weather data to InfluxDB" %}}

Write the NOAA Bay Area weather data to InfluxDB

Use the InfluxDB v2 or v1 API to write the NOAA Bay Area weather sample data to {{< product-name >}}.

{{< code-tabs-wrapper >}} {{% code-tabs %}} v2 API v1 API {{% /code-tabs %}} {{% code-tab-content %}}

{{% code-placeholders "API_TOKEN|BUCKET_NAME" %}}

curl --request POST \
  https://{{< influxdb/host >}}/api/v2/write?bucket=BUCKET_NAME \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary "$(curl --request GET https://docs.influxdata.com/downloads/bay-area-weather.lp)"

{{% /code-placeholders %}}

{{% /code-tab-content %}} {{% code-tab-content %}}

{{% code-placeholders "API_TOKEN|BUCKET_NAME" "magenta" %}}

curl --request POST \
  https://{{< influxdb/host >}}/write?db=BUCKET_NAME \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary "$(curl --request GET https://docs.influxdata.com/downloads/bay-area-weather.lp)"

{{% /code-placeholders %}}

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Replace the following in the sample script:

  • {{% code-placeholder-key %}}BUCKET_NAME{{% /code-placeholder-key %}}: your InfluxDB Cloud Serverless bucket
  • {{% code-placeholder-key %}}API_TOKEN{{% /code-placeholder-key %}}: an API token with sufficient permissions to the bucket

{{% /expand %}} {{< /expand-wrapper >}}

Bitcoin price data

The Bitcoin price sample dataset provides Bitcoin prices from 2023-05-01T00:00:00Z to 2023-05-15T00:00:00Z—Powered by CoinDesk.

Time Range

2023-05-01T00:19:00Z to 2023-05-14T23:48:00Z

Schema
  • bitcoin (measurement)
    • tags:
      • code
        • EUR
        • GBP
        • USD
      • crypto
        • bitcoin
      • description
        • Euro
        • British Pound Sterling
        • United States Dollar
      • symbol
        • &euro; (€)
        • &pound; (£)
        • &#36; ($)
    • fields
      • price (float)

{{< expand-wrapper >}} {{% expand "Write the Bitcoin sample data to InfluxDB" %}}

Write the Bitcoin price sample data to InfluxDB

Use the InfluxDB v2 or v1 API to write the Bitcoin price sample data to {{< product-name >}}.

{{< code-tabs-wrapper >}} {{% code-tabs %}} v2 API v1 API {{% /code-tabs %}} {{% code-tab-content %}}

{{% code-placeholders "API_TOKEN|BUCKET_NAME" "magenta" %}}

curl --request POST \
  https://{{< influxdb/host >}}/api/v2/write?bucket=BUCKET_NAME \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary "$(curl --request GET https://docs.influxdata.com/downloads/bitcoin.lp)"

{{% /code-placeholders %}}

{{% /code-tab-content %}} {{% code-tab-content %}}

{{% code-placeholders "API_TOKEN|BUCKET_NAME" "magenta" %}}

curl --request POST \
  https://{{< influxdb/host >}}/write?db=BUCKET_NAME \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary "$(curl --request GET https://docs.influxdata.com/downloads/bitcoin.lp)"

{{% /code-placeholders %}}

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Replace the following in the sample script:

  • {{% code-placeholder-key %}}BUCKET_NAME{{% /code-placeholder-key %}}: your InfluxDB Cloud Serverless bucket
  • {{% code-placeholder-key %}}API_TOKEN{{% /code-placeholder-key %}}: an API token with sufficient permissions to the bucket

{{% /expand %}} {{< /expand-wrapper >}}

Random numbers sample data

Includes two fields with randomly generated numbers reported every minute. Each field has a specific range of randomly generated numbers. This sample dataset is used to demonstrate mathematic operations and transformation functions.

Time Range

2023-01-01T00:00:00Z to 2023-01-01T12:00:00Z

Schema
  • numbers (measurement)
    • fields
      • a (float between -1 and 1)
      • b (float between -3 and 3)

{{< expand-wrapper >}} {{% expand "Write the random number sample data to InfluxDB" %}}

Write the random number sample data to InfluxDB

Use the InfluxDB v2 or v1 API to write the random number sample data to {{< product-name >}}.

{{< code-tabs-wrapper >}} {{% code-tabs %}} v2 API v1 API {{% /code-tabs %}} {{% code-tab-content %}}

{{% code-placeholders "API_TOKEN|BUCKET_NAME" "magenta" %}}

curl --request POST \
  https://{{< influxdb/host >}}/api/v2/write?bucket=BUCKET_NAME \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-Type: text/plain; charset=utf-8" \
  --header "Accept: application/json" \
  --data-binary "$(curl --request GET https://docs.influxdata.com/downloads/random-numbers.lp)"

{{% /code-placeholders %}}

{{% /code-tab-content %}} {{% code-tab-content %}}

{{% code-placeholders "API_TOKEN|BUCKET_NAME" "magenta" %}}

curl --request POST \
  https://{{< influxdb/host >}}/write?db=BUCKET_NAME \
  --header "Authorization: Bearer API_TOKEN" \
  --header "Content-type: text/plain; charset=utf-8" \
  --data-binary "$(curl --request GET https://docs.influxdata.com/downloads/random-numbers.lp)"

{{% /code-placeholders %}}

{{% /code-tab-content %}} {{< /code-tabs-wrapper >}}

Replace the following in the sample script:

  • {{% code-placeholder-key %}}BUCKET_NAME{{% /code-placeholder-key %}}: your InfluxDB Cloud Serverless bucket
  • {{% code-placeholder-key %}}API_TOKEN{{% /code-placeholder-key %}}: an API token with sufficient permissions to the bucket

{{% /expand %}} {{< /expand-wrapper >}}