JDBC Driver for Instagram

Build 23.0.8868


Query Online Followers insights as hourly totals. Requires the instagram_basic and instagram_manage_insights scopes.


You can use the FromDateTime and ToDateTime columns to filter the results by a timeframe. The driver uses the Instagram API to process filters that refer to a timeframe or Id and will process other filters client-side within itself.

  • The default query returns results as hourly totals during the last 7 days.

    SELECT * FROM OnlineFollowers

  • The maximum timeframe you can specify with the FromDateTime and ToDateTime columns is 30 days (2592000 s).

    SELECT * FROM OnlineFollowers WHERE FromDateTime = '2018/01/01' AND ToDateTime = '2018/01/30' 


Name Type Description
InstagramBusinessAccountId String The unique identifier for the business account.
StartTime Datetime The start datetime of the insight.
EndTime Datetime The end datetime of the insight.
Onlinefollowers Integer The number of the online followers at the specific time.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
FromDateTime Datetime The earliest time for insight data to have been collected.
ToDateTime Datetime The latest time for insight data to have been collected.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8868