rilldata · lovincyrus · Aug 5, 2025 · Aug 5, 2025 · Aug 5, 2025 · Aug 5, 2025
diff --git a/runtime/drivers/athena/athena.go b/runtime/drivers/athena/athena.go
@@ -34,56 +34,27 @@ var spec = drivers.Spec{
 	DocsURL:     "https://docs.rilldata.com/connect/data-source/athena",
 	ConfigProperties: []*drivers.PropertySpec{
 		{
-			Key:    "aws_access_key_id",
-			Type:   drivers.StringPropertyType,
-			Secret: true,
+			Key:         "aws_access_key_id",
+			Type:        drivers.StringPropertyType,
+			DisplayName: "AWS access key ID",
+			Description: "AWS access key ID",
+			Required:    true,
+			Secret:      true,
 		},
 		{
-			Key:    "aws_secret_access_key",
-			Type:   drivers.StringPropertyType,
-			Secret: true,
-		},
-	},
-	// Important: Any edits to the below properties must be accompanied by changes to the client-side form validation schemas.
-	SourceProperties: []*drivers.PropertySpec{
-		{
-			Key:         "sql",
+			Key:         "aws_secret_access_key",
 			Type:        drivers.StringPropertyType,
+			DisplayName: "AWS secret access key",
+			Description: "AWS secret access key",
 			Required:    true,
-			DisplayName: "SQL",
-			Description: "Query to extract data from Athena.",
-			Placeholder: "select * from catalog.table;",
+			Secret:      true,
 		},
 		{
 			Key:         "output_location",
 			Type:        drivers.StringPropertyType,
 			DisplayName: "S3 output location",
 			Description: "An output location for query result is required either through the workgroup result configuration setting or set here.",
 			Placeholder: "s3://bucket-name/path/",
-			Required:    false,
-		},
-		{
-			Key:         "workgroup",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "AWS Athena workgroup",
-			Description: "AWS Athena workgroup to use for queries. Default is primary",
-			Placeholder: "primary",
-			Required:    false,
-		},
-		{
-			Key:         "region",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "AWS region",
-			Description: "AWS region to connect to Athena and the output location.",
-			Placeholder: "us-east-1",
-			Required:    false,
-		},
-		{
-			Key:         "name",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Source name",
-			Description: "The name of the source",
-			Placeholder: "my_new_source",
 			Required:    true,
 		},
 	},

diff --git a/runtime/drivers/bigquery/bigquery.go b/runtime/drivers/bigquery/bigquery.go
@@ -28,53 +28,22 @@ var spec = drivers.Spec{
 	DocsURL:     "https://docs.rilldata.com/connect/data-source/bigquery",
 	ConfigProperties: []*drivers.PropertySpec{
 		{
-			Key:  "google_application_credentials",
-			Type: drivers.FilePropertyType,
-			Hint: "Enter path of file to load from.",
+			Key:         "google_application_credentials",
+			Type:        drivers.InformationalPropertyType,
+			DisplayName: "GCP credentials",
+			Description: "GCP credentials inferred from your local environment.",
+			Hint:        "Set your local credentials: <code>gcloud auth application-default login</code> Click to learn more.",
+			DocsURL:     "https://docs.rilldata.com/connect/data-source/gcs#rill-developer-local-credentials",
 		},
 		{
 			Key:         "project_id",
 			Type:        drivers.StringPropertyType,
 			Required:    false,
 			DisplayName: "Project ID",
-			Description: "Default Google project ID.",
-		},
-	},
-	// Important: Any edits to the below properties must be accompanied by changes to the client-side form validation schemas.
-	SourceProperties: []*drivers.PropertySpec{
-		{
-			Key:         "sql",
-			Type:        drivers.StringPropertyType,
-			Required:    true,
-			DisplayName: "SQL",
-			Description: "Query to extract data from BigQuery.",
-			Placeholder: "select * from project.dataset.table;",
-		},
-		{
-			Key:         "project_id",
-			Type:        drivers.StringPropertyType,
-			Required:    true,
-			DisplayName: "Project ID",
 			Description: "Google project ID.",
 			Placeholder: "my-project",
 			Hint:        "Rill will use the project ID from your local credentials, unless set here. Set this if no project ID configured in credentials.",
 		},
-		{
-			Key:         "name",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Source name",
-			Description: "The name of the source",
-			Placeholder: "my_new_source",
-			Required:    true,
-		},
-		{
-			Key:         "google_application_credentials",
-			Type:        drivers.InformationalPropertyType,
-			DisplayName: "GCP credentials",
-			Description: "GCP credentials inferred from your local environment.",
-			Hint:        "Set your local credentials: <code>gcloud auth application-default login</code> Click to learn more.",
-			DocsURL:     "https://docs.rilldata.com/connect/data-source/gcs#rill-developer-local-credentials",
-		},
 	},
 	ImplementsWarehouse: true,
 }

diff --git a/runtime/drivers/duckdb/duckdb.go b/runtime/drivers/duckdb/duckdb.go
@@ -49,33 +49,6 @@ var spec = drivers.Spec{
 			Placeholder: "/path/to/main.db",
 		},
 	},
-	// Important: Any edits to the below properties must be accompanied by changes to the client-side form validation schemas.
-	SourceProperties: []*drivers.PropertySpec{
-		{
-			Key:         "db",
-			Type:        drivers.StringPropertyType,
-			Required:    true,
-			DisplayName: "DB",
-			Description: "Path to DuckDB database",
-			Placeholder: "/path/to/duckdb.db",
-		},
-		{
-			Key:         "sql",
-			Type:        drivers.StringPropertyType,
-			Required:    true,
-			DisplayName: "SQL",
-			Description: "Query to extract data from DuckDB.",
-			Placeholder: "select * from table;",
-		},
-		{
-			Key:         "name",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Source name",
-			Description: "The name of the source",
-			Placeholder: "my_new_source",
-			Required:    true,
-		},
-	},
 	ImplementsOLAP: true,
 }
 

diff --git a/runtime/drivers/mysql/mysql.go b/runtime/drivers/mysql/mysql.go
@@ -27,41 +27,16 @@ var spec = drivers.Spec{
 	Description: "Connect to MySQL.",
 	DocsURL:     "https://docs.rilldata.com/connect/data-source/mysql",
 	ConfigProperties: []*drivers.PropertySpec{
-		{
-			Key:         "dsn",
-			Type:        drivers.StringPropertyType,
-			Placeholder: "mysql://user:password@host:3306/my-db",
-			Secret:      true,
-		},
-	},
-	// Important: Any edits to the below properties must be accompanied by changes to the client-side form validation schemas.
-	SourceProperties: []*drivers.PropertySpec{
-		{
-			Key:         "sql",
-			Type:        drivers.StringPropertyType,
-			Required:    true,
-			DisplayName: "SQL",
-			Description: "Query to extract data from MySQL.",
-			Placeholder: "select * from table;",
-		},
 		{
 			Key:         "dsn",
 			Type:        drivers.StringPropertyType,
 			DisplayName: "MySQL Connection String",
-			Required:    false,
+			Required:    true,
 			DocsURL:     "https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html#connecting-using-uri",
 			Placeholder: "mysql://user:password@host:3306/my-db",
 			Hint:        "Can be configured here or by setting the 'connector.mysql.dsn' environment variable (using '.env' or '--env')",
 			Secret:      true,
 		},
-		{
-			Key:         "name",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Source name",
-			Description: "The name of the source",
-			Placeholder: "my_new_source",
-			Required:    true,
-		},
 	},
 	ImplementsSQLStore: true,
 }

diff --git a/runtime/drivers/postgres/postgres.go b/runtime/drivers/postgres/postgres.go
@@ -27,39 +27,16 @@ var spec = drivers.Spec{
 	Description: "Connect to Postgres.",
 	DocsURL:     "https://docs.rilldata.com/connect/data-source/postgres",
 	ConfigProperties: []*drivers.PropertySpec{
-		{
-			Key:    "database_url",
-			Secret: true,
-		},
-	},
-	// Important: Any edits to the below properties must be accompanied by changes to the client-side form validation schemas.
-	SourceProperties: []*drivers.PropertySpec{
-		{
-			Key:         "sql",
-			Type:        drivers.StringPropertyType,
-			Required:    true,
-			DisplayName: "SQL",
-			Description: "Query to extract data from Postgres.",
-			Placeholder: "select * from table;",
-		},
 		{
 			Key:         "database_url",
 			Type:        drivers.StringPropertyType,
 			DisplayName: "Postgres Connection String",
-			Required:    false,
+			Required:    true,
 			DocsURL:     "https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING",
 			Placeholder: "postgresql://postgres:postgres@localhost:5432/postgres",
 			Hint:        "Can be configured here or by setting the 'connector.postgres.database_url' environment variable (using '.env' or '--env')",
 			Secret:      true,
 		},
-		{
-			Key:         "name",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Source name",
-			Description: "The name of the source",
-			Placeholder: "my_new_source",
-			Required:    true,
-		},
 	},
 	ImplementsSQLStore: true,
 }

diff --git a/runtime/drivers/redshift/redshift.go b/runtime/drivers/redshift/redshift.go
@@ -31,33 +31,20 @@ var spec = drivers.Spec{
 	DocsURL:     "https://docs.rilldata.com/connect/data-source/redshift",
 	ConfigProperties: []*drivers.PropertySpec{
 		{
-			Key:    "aws_access_key_id",
-			Type:   drivers.StringPropertyType,
-			Secret: true,
-		},
-		{
-			Key:    "aws_secret_access_key",
-			Type:   drivers.StringPropertyType,
-			Secret: true,
-		},
-	},
-	// Important: Any edits to the below properties must be accompanied by changes to the client-side form validation schemas.
-	SourceProperties: []*drivers.PropertySpec{
-		{
-			Key:         "sql",
+			Key:         "aws_access_key_id",
 			Type:        drivers.StringPropertyType,
+			DisplayName: "AWS access key ID",
+			Description: "AWS access key ID",
 			Required:    true,
-			DisplayName: "SQL",
-			Description: "Query to extract data from Redshift.",
-			Placeholder: "select * from public.table;",
+			Secret:      true,
 		},
 		{
-			Key:         "output_location",
+			Key:         "aws_secret_access_key",
 			Type:        drivers.StringPropertyType,
-			DisplayName: "S3 output location",
-			Description: "Output location in S3 for temporary data.",
-			Placeholder: "s3://bucket-name/path/",
+			DisplayName: "AWS secret access key",
+			Description: "AWS secret access key",
 			Required:    true,
+			Secret:      true,
 		},
 		{
 			Key:         "workgroup",
@@ -83,30 +70,6 @@ var spec = drivers.Spec{
 			Placeholder: "dev",
 			Required:    true,
 		},
-		{
-			Key:         "cluster_identifier",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Redshift cluster identifier",
-			Description: "Redshift cluster identifier",
-			Placeholder: "redshift-cluster-1",
-			Required:    false,
-		},
-		{
-			Key:         "role_arn",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Redshift role ARN",
-			Description: "Redshift role ARN",
-			Placeholder: "arn:aws:iam::03214372:role/service-role/AmazonRedshift-CommandsAccessRole-20240307T203902",
-			Required:    true,
-		},
-		{
-			Key:         "name",
-			Type:        drivers.StringPropertyType,
-			DisplayName: "Source name",
-			Description: "The name of the source",
-			Placeholder: "my_new_source",
-			Required:    true,
-		},
 	},
 	ImplementsWarehouse: true,
 }