```{ "type": "index_parallel", "id": "postgres...
# troubleshooting
s
Copy code
{
  "type": "index_parallel",
  "id": "postgresql_mhere",
  "spec": {
    "dataSchema": {
      "dataSource": "postgresql_mhere",
      "timestampSpec": {
        "format": "iso",
        "column": "date"
      },
      "dimensionsSpec": {
        "dimensions": [
          "user_id",
          "app_id",
          "date"
        ]
      }
    },
    "ioConfig": {
      "type": "index_parallel",
      "inputSource": {
        "type": "sql",
        "database": {
          "type": "postgresql",
          "connectorConfig": {
            "connectURI": "jdbc:<postgresql://127.0.0.1:5432/mhere>",
            "user": "postgres",
            "password": "postgres"
          }
        },
        "sqls": [
          "SELECT *  FROM transactions limit 10"
        ]
      }
    },
    "tuningConfig": {
      "type": "index_parallel",
      "partitionsSpec": {
        "type": "dynamic"
      }
    }
  }
}