Airbyte connector not detecting column types

[aamoronatti]

Hello!
I have a base planetscale schema that looks like this

CREATE TABLE `folder` (
  `id` varchar(255) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` datetime(3) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` enum('video','layout','trash','blackhole','template') NOT NULL DEFAULT 'video',
  `workspaceId` varchar(255) DEFAULT NULL,
  `parentId` varchar(255) DEFAULT NULL,
  `originId` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `folder_workspaceId_idx` (`workspaceId`),
  KEY `folder_parentId_idx` (`parentId`),
  KEY `folder_type_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

Airbyte is not recognizing workspaceId, parentId and originId.

In planetscale there arent any null values in those fields but airbyte detects those values as Unknown.

createdAt->Datetime
id->String, primary key, cursor
originId->Unknown
parentId->Unknown
title->String
type->String
updatedAt->Datetime
workspaceId->Unknown

Any suggestion?

I've asked airbyte but they told me to contact planetscale support.

[orware]

Hello @aamoronatti,

We will continue working with you via the support ticket that was filed that linked to this page since it'll be easier to share further details within the ticket and hopefully get this resolved for you!