This app captures analytics data and stores it in a private analytics database hosted by Amazon Web Services in the United States of America.

The app collects limited information to help us determine the areas to focus on our future releases. We include the Support Entitlement Number (SEN) and other anonymous identifiers to improve the customer support experience. All fields that could potentially contain personally identifiable information are cleansed of that data before it is transmitted to our servers.

You can opt-out at any point by toggling the analytics option to "off" within the app's Global Configuration screen.

Install

This data is collected each time the app is installed.

{
  "event": {
    "timestamp": "2021-01-14T09:57:24.266Z",
    "created_at": "2021-01-14T09:57:24.266Z",
    "id": "60001584c7f07c0001209773"
  },
  "eventInfo": {
    "type": "installed"
  },
  "hostInfo": {
    "clientKey": "b776f19a-286b-38f2-8f49-e60cf7e6ca51",
    "baseUrl": "https://xxxxxxxxxx.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.856.0",
    "pluginKey": "org.swift.confluence.sql"
  }
}

Uninstall

This data is collected each time the app is uninstalled.

{
  "event": {
    "timestamp": "2021-01-13T06:17:00.678Z",
    "created_at": "2021-01-13T06:17:00.678Z",
    "id": "5ffe905c700de90001a09cdc"
  },
  "eventInfo": {
    "type": "uninstalled"
  },
  "hostInfo": {
    "clientKey": "b776f19a-286b-38f2-8f49-e60cf7e6ca51",
    "baseUrl": "https://xxxxxxxxxx.atlassian.net/wiki",
    "productType": "confluence"
  },
  "pluginInfo": {
    "pluginsVersion": "1.851.0",
    "pluginKey": "org.swift.confluence.sql"
  }
}

Global configuration

This data is collected when the administrator changes the app's global configuration.

{
  "event": { 
	"timestamp": "2021-02-15T05:41:33.630Z", 
	"created_at": "2021-02-15T05:41:33.630Z", 
	"id": "602a098debb0130001027568" 
  }, 
  "eventInfo": { 
	"userId": "5d28bc13cbb3670c1fa15a6b", 
	"type": "globalConfig", 
	"settings": { 
	  "transactionIsolation": "NONE", 
	  "limit": "5000",  
	  "rowsPerPage": "100"
	} 
  }, 
  "hostInfo": { 
	"host": "https://xxxxxxxxxx.atlassian.net/wiki" 
  }, 
  "pluginInfo": { 
	"links": { 
	  "marketplace": [ 
	    { 
		  "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql" 
		} 
	  ], 
	  "self": [ 
		{ 
		  "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql" 
		} 
	  ] 
    }, 
    "host": { 
	  "product": "Confluence" 
    }, 
    "lastUpdated": "2021-02-15T05:04:34Z", 
    "state": "ENABLED", 
    "version": "1.0", 
    "key": "org.swift.confluence.sql", 
    "installedDate": "2021-02-15T05:04:32Z" 
  }
}

Data source profile configuration

This data is collected when a Confluence administrator creates or updates a data source profile.

{
  "event": {
    "timestamp": "2021-02-22T04:54:49.969Z",
    "created_at": "2021-02-22T04:54:49.969Z",
    "id": "603339196d6b8400015ac5e6"
  },
  "eventInfo": {
    "profileName": "test",
    "type": "profileAdded",
    "userId": "5d28bc13cbb3670c1fa15a6b",
    "settings": {
      "userName": "",
      "authType": "basic",
      "password": "",
      "limitRowsProcessed": null,
      "limitQueryTime": null,
      "hostName": "",
      "portNumber": 243,
      "databaseName": "",
      "databaseType": "postgresql"
    }
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-02-22T04:18:51Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-02-22T04:18:47Z"
  }
}

Macro configuration

This data is collected when a user inserts or updated the configuration of an SQL for Confluence page macro.

{
  "event": {
    "timestamp": "2021-01-14T12:08:09.730Z",
    "created_at": "2021-01-14T12:08:09.730Z",
    "id": "600034298d85f10001977434"
  },
  "eventInfo": {
    "pageId": "146440216",
    "macroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "parameters": {
      "displayDataFilter": "true",
      "pagination": "true",
      "bodyData": true,
      "dataSource": true
    },
    "type": "macroConfigured"
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-01-14T09:57:22Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-01-14T09:57:19Z"
  }
}

Page render

This data is collected each time the page with an SQL for Confluence macro is refreshed.

{
  "keen": {
    "timestamp": "2021-01-14T12:05:49.682Z",
    "created_at": "2021-01-14T12:05:49.682Z",
    "id": "6000339d6205f400018a1c87"
  },
  "eventInfo": {
    "pageId": "146440216",
    "parameters": {
      "displayDataFilter": "true",
      "pagination": "true",
      "bodyData": true,
      "dataSource": true
    },
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "renderTime": 27545.864999992773,
    "macroId": "a6654f12-bfba-4dd4-a735-cd5129fd7fa8",
    "type": "pageRender"
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-01-14T09:57:22Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-01-14T09:57:19Z"
  }
}

Error

This data is collected whenever a user encounters an error using SQL for Confluence.

{
  "event": {
    "timestamp": "2021-02-24T12:26:49.161Z",
    "created_at": "2021-02-24T12:26:49.161Z",
    "id": "603646096cd44b00010da39d"
  },
  "eventInfo": {
    "pageId": "1000177665",
    "parameters": {
      "pagination": "false",
      "pageSize": 25,
      "queryTimeout": 120,
      "limit": "50",
      "dataSource": true,
      "showSql": "true",
      "rowsPerPage": 25
    },
    "type": "pageRender",
    "userId": "557058:1701f082-9690-4a9d-8581-022b7fba2903",
    "macroId": "3b319870-29ab-4256-a67e-2de2b0e77ae4",
    "error": {
      "message": "Profile Not Found"
    },
    "renderTime": 6548.155000000406,
    "macroName": "sql-query"
  },
  "hostInfo": {
    "host": "https://xxxxxxxxxx.atlassian.net/wiki"
  },
  "pluginInfo": {
    "links": {
      "marketplace": [
        {
          "href": "https://marketplace.atlassian.com/plugins/org.swift.confluence.sql"
        }
      ],
      "self": [
        {
          "href": "https://xxxxxxxxxx.atlassian.net/wiki/rest/atlassian-connect/1/addons/org.swift.confluence.sql"
        }
      ]
    },
    "host": {
      "product": "Confluence"
    },
    "lastUpdated": "2021-02-24T08:22:43Z",
    "state": "ENABLED",
    "version": "1.0",
    "key": "org.swift.confluence.sql",
    "installedDate": "2021-02-24T08:22:41Z"
  }
}