Movatterモバイル変換


[0]ホーム

URL:



Get started with a free trial today

Already have an account? Sign in

Darksky

Darksky is supported by the Singer community
This integration is powered bySinger's Darksky tap. For support,visit the GitHub repo orjoin the Singer Slack.

Darksky feature snapshot

A high-level look at Stitch's Darksky (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on January 3, 2020

Supported by

Singer Community

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-darksky

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Unsupported

Column selection

Unsupported

Select all

Unsupported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Darksky

Step 1: Retrieve your Darksky secret key

  1. Log into your Darksky API accounthere.
  2. On your account home page, your Secret Key is available at the top of the page. You will use this Secret Key to add your integration.

Step 2: Add Darksky as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click theAdd Integration button.

  3. Click theDarksky icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Darksky” would create a schema calledstitch_darksky in the destination.Note: Schema names cannot be changed after you save the integration.

  5. In theLanguage field, enter the language code. Ex: ‘en’ for English, ‘es’ for Spanish, and ‘fr’ for French. For a full list of available language codes, check theRequest Parameters section of theDarksky API documentation.
  6. In theLocation List field, enter the latitude and longitude of the the locations to be returned for weather forecast information. The locations must be semi-colon deliniated. Ex:<latitude>,<longitude> is an accepted value for a single location, and<latitude>,<longitude>;<latitude>,<longitude>; ... etc is accepted for multiple locations.
  7. In theSecret Key field, paste your Darksky secret key that you retrieved inStep 1.
  8. In theUnits field, enter the measurement system to be returned for weather forecast information. Ex: ‘us’ for Imperial Units, and ‘si’ for International System of Units. For a full list of available measurement systems, check theRequest Parameters section of theDark Sky API documentation

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Darksky integration. This means that dataequal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Darksky’s default setting of1 year. For a detailed look at historical replication jobs, check out theSyncing Historical SaaS Data guide.

Step 4: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to theReplication Scheduling documentation for more information.

In theReplication Frequency section, you’ll create the integration’sreplication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Darksky integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See theUnderstanding and Reducing Your Row Usage guide for tips on reducing your usage.

Initial and historical replication jobs

After you finish setting up Darksky, itsSync Status may show asPending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, aPending status indicates that Stitch is in the process of scheduling the initial replication job for the integration.This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to theAnchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure topause ordelete the integration to prevent unwanted usage.

Darksky table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is forversion 1 of this integration.

This is the latest version of the Darksky integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs >customers), while case is maintained in PostgreSQL destinations (CusTomERs >CusTomERs). Refer to theLoading Guide for your destination for more info.

forecast

Theforecasts table contains weather conditions for a particular date and location. The locations are determined by the locations entered into theLocations field in Stitch.

Note: The units data points are returned in is determined by the value entered into theUnits field in Stitch. For example: Ifus is entered, data will be returned in Imperial units.

Replication Method

Key-based Incremental

Primary Keys

forecast_date

latitude

longitude

Replication Key

forecast_date

Useful links

Darksky documentation

forecast schema on GitHub

Darksky API method

daily

OBJECT

apparent_temperature_high

NUMBER

apparent_temperature_high_time

DATE-TIME

apparent_temperature_low

NUMBER

apparent_temperature_low_time

DATE-TIME

apparent_temperature_max

NUMBER

apparent_temperature_max_time

DATE-TIME

apparent_temperature_min

NUMBER

apparent_temperature_min_time

DATE-TIME

cloud_cover

NUMBER

dew_point

NUMBER

humidity

NUMBER

icon

STRING

moon_phase

NUMBER

precip_accumululation

NUMBER

precip_intensity

NUMBER

precip_intensity_max

NUMBER

precip_intensity_max_time

DATE-TIME

precip_probability

NUMBER

precip_type

STRING

pressure

NUMBER

summary

STRING

sunrise_time

DATE-TIME

sunset_time

DATE-TIME

temperature_high

NUMBER

temperature_high_time

DATE-TIME

temperature_low

NUMBER

temperature_low_time

DATE-TIME

temperature_max

NUMBER

temperature_max_time

DATE-TIME

temperature_min

NUMBER

temperature_min_time

DATE-TIME

time

DATE-TIME

uv_index

INTEGER

uv_index_time

DATE-TIME

visibility

NUMBER

wind_bearing

INTEGER

wind_speed

NUMBER

end_time

DATE-TIME

flags

OBJECT

nearest_station

NUMBER

sources

ARRAY

units

STRING

forecast_date

DATE-TIME

hourly

OBJECT

data

ARRAY

apparent_temperature

DATE-TIME

cloud_cover

NUMBER

dew_point

NUMBER

humidity

NUMBER

icon

STRING

ozone

NUMBER

precip_intensity

NUMBER

precip_probability

NUMBER

precip_type

STRING

pressure

NUMBER

summary

STRING

temperature

NUMBER

time

DATE-TIME

uv_index

INTEGER

visibility

NUMBER

wind_bearing

INTEGER

wind_gust

NUMBER

wind_speed

NUMBER

icon

STRING

summary

STRING

latitude

NUMBER

local_date

STRING

longitude

NUMBER

offset

NUMBER

start_time

DATE-TIME

timezone

STRING

RelatedTroubleshooting

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.


[8]ページ先頭

©2009-2026 Movatter.jp