Hey,
I'm very excited by the model feature brought by version 0.42.*.
As I'm diving through the API, I see that models are considered as "special cards" as we go through the /api/card endpoint to get them (https://www.metabase.com/docs/latest/api-documentation.html#get-apicard).
It seems possible to get models, but not to create one. Am I missing a point ?
FYI, informations I got from a get request on a model :
{'archived': False,
'average_query_time': 539.0,
'cache_ttl': None,
'can_write': True,
'collection': {'archived': False,
'authority_level': None,
'color': '#509EE3',
'description': ""
'id': 35,
'location': '/',
'name': 'DB',
'namespace': None,
'personal_owner_id': None,
'slug': 'db'},
'collection_id': 35,
'collection_position': None,
'created_at': '2022-02-18T17:46:04.330424Z',
'creator': {'common_name': 'Admin admin',
'date_joined': '2020-09-24T11:00:23.2911Z',
'email': 'admin@example.org',
'first_name': 'admin',
'id': 17,
'is_qbnewb': False,
'is_superuser': True,
'last_login': '2022-02-18T18:08:55.382678Z',
'last_name': 'admin'},
'creator_id': 17,
'dashboard_count': 0,
'database_id': 19,
'dataset': True,
'dataset_query': {'database': 19,
'native': {'query': 'select * from visits',
'template-tags': {}},
'type': 'native'},
'description': None,
'display': 'table',
'embedding_params': None,
'enable_embedding': False,
'id': 484,
'last-edit-info': {'email': 'admin@example.org',
'first_name': 'Admin',
'id': 17,
'last_name': 'Admin',
'timestamp': '2022-02-18T17:46:10.55212Z'},
'last_query_start': '2022-02-18T18:03:31.007137Z',
'made_public_by_id': None,
'moderation_reviews': [],
'name': 'Meta - visits',
'public_uuid': None,
'query_type': 'native',
'result_metadata': [{'base_type': 'type/Integer',
'display_name': 'id',
'effective_type': 'type/Integer',
'field_ref': ['field',
'id',
{'base-type': 'type/Integer'}],
'fingerprint': None,
'name': 'id',
'semantic_type': 'type/PK'},
{'base_type': 'type/Text',
'display_name': 'email',
'effective_type': 'type/Text',
'field_ref': ['field',
'email',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1777,
'nil%': 0},
'type': {'type/Text': {'average-length': 25.5331088664422,
'percent-email': 0.9966329966329966,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'email',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'encrypted_password',
'effective_type': 'type/Text',
'field_ref': ['field',
'encrypted_password',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1781,
'nil%': 0},
'type': {'type/Text': {'average-length': 59.93265993265993,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'encrypted_password',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'reset_password_token',
'effective_type': 'type/Text',
'field_ref': ['field',
'reset_password_token',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 24,
'nil%': 0.9870931537598204},
'type': {'type/Text': {'average-length': 0.8260381593714927,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'reset_password_token',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'reset_password_sent_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'reset_password_sent_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 24,
'nil%': 0.9870931537598204},
'type': {'type/DateTime': {'earliest': '2021-02-04T14:16:42.125086+01:00',
'latest': '2021-06-10T10:37:04.858044+02:00'}}},
'name': 'reset_password_sent_at',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'remember_created_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'remember_created_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 108,
'nil%': 0.9399551066217733},
'type': {'type/DateTime': {'earliest': '2021-01-29T08:44:48.270131+01:00',
'latest': '2021-07-14T08:12:44.289019+02:00'}}},
'name': 'remember_created_at',
'semantic_type': 'type/CreationTimestamp'},
{'base_type': 'type/Integer',
'display_name': 'sign_in_count',
'effective_type': 'type/Integer',
'field_ref': ['field',
'sign_in_count',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 21,
'nil%': 0},
'type': {'type/Number': {'avg': 1.8181818181818181,
'max': 30,
'min': 0,
'q1': 0.8327990578562801,
'q3': 1.8096662350467603,
'sd': 2.2488490922700866}}},
'name': 'sign_in_count',
'semantic_type': 'type/Quantity'},
{'base_type': 'type/DateTime',
'display_name': 'current_sign_in_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'current_sign_in_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1781,
'nil%': 0.001122334455667789},
'type': {'type/DateTime': {'earliest': '2021-01-20T13:39:35.067821+01:00',
'latest': '2021-07-20T12:59:29.429399+02:00'}}},
'name': 'current_sign_in_at',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'last_sign_in_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'last_sign_in_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1781,
'nil%': 0.001122334455667789},
'type': {'type/DateTime': {'earliest': '2021-01-20T13:39:35.067821+01:00',
'latest': '2021-07-20T11:23:55.182817+02:00'}}},
'name': 'last_sign_in_at',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'current_sign_in_ip',
'effective_type': 'type/Text',
'field_ref': ['field',
'current_sign_in_ip',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1412,
'nil%': 0.001122334455667789},
'type': {'type/Text': {'average-length': 13.05499438832772,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'current_sign_in_ip',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'last_sign_in_ip',
'effective_type': 'type/Text',
'field_ref': ['field',
'last_sign_in_ip',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1413,
'nil%': 0.001122334455667789},
'type': {'type/Text': {'average-length': 13.05611672278339,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'last_sign_in_ip',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'created_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'created_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1782,
'nil%': 0},
'type': {'type/DateTime': {'earliest': '2021-01-20T13:39:35.02855+01:00',
'latest': '2021-07-20T11:23:55.095369+02:00'}}},
'name': 'created_at',
'semantic_type': 'type/CreationTimestamp'},
{'base_type': 'type/DateTime',
'display_name': 'updated_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'updated_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1782,
'nil%': 0},
'type': {'type/DateTime': {'earliest': '2021-01-20T13:39:35.069875+01:00',
'latest': '2021-07-20T13:00:13.485185+02:00'}}},
'name': 'updated_at',
'semantic_type': 'type/UpdatedTimestamp'},
{'base_type': 'type/Text',
'display_name': 'invitation_token',
'effective_type': 'type/Text',
'field_ref': ['field',
'invitation_token',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0.999438832772166},
'type': {'type/Text': {'average-length': 0.03591470258136925,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'invitation_token',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'invitation_created_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'invitation_created_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 6,
'nil%': 0.9971941638608305},
'type': {'type/DateTime': {'earliest': '2021-01-28T09:49:57.734406+01:00',
'latest': '2021-01-28T10:29:59.22846+01:00'}}},
'name': 'invitation_created_at',
'semantic_type': 'type/CreationTimestamp'},
{'base_type': 'type/DateTime',
'display_name': 'invitation_sent_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'invitation_sent_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 6,
'nil%': 0.9971941638608305},
'type': {'type/DateTime': {'earliest': '2021-01-28T09:49:57.734406+01:00',
'latest': '2021-01-28T10:29:59.22846+01:00'}}},
'name': 'invitation_sent_at',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'invitation_accepted_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'invitation_accepted_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 5,
'nil%': 0.9977553310886644},
'type': {'type/DateTime': {'earliest': '2021-01-28T09:51:57.190669+01:00',
'latest': '2021-01-28T11:02:56.042832+01:00'}}},
'name': 'invitation_accepted_at',
'semantic_type': None},
{'base_type': 'type/Integer',
'display_name': 'invitation_limit',
'effective_type': 'type/Integer',
'field_ref': ['field',
'invitation_limit',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 1},
'type': {'type/Number': {'avg': None,
'max': None,
'min': None,
'q1': None,
'q3': None,
'sd': None}}},
'name': 'invitation_limit',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'invited_by_type',
'effective_type': 'type/Text',
'field_ref': ['field',
'invited_by_type',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0.9971941638608305},
'type': {'type/Text': {'average-length': 0.06453423120089787,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'invited_by_type',
'semantic_type': 'type/Category'},
{'base_type': 'type/Integer',
'display_name': 'invited_by_id',
'effective_type': 'type/Integer',
'field_ref': ['field',
'invited_by_id',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 3,
'nil%': 0.9971941638608305},
'type': {'type/Number': {'avg': 29.4,
'max': 45,
'min': 6,
'q1': 10.731493398826053,
'q3': 45,
'sd': 21.361179742701477}}},
'name': 'invited_by_id',
'semantic_type': None},
{'base_type': 'type/Integer',
'display_name': 'invitations_count',
'effective_type': 'type/Integer',
'field_ref': ['field',
'invitations_count',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 0},
'type': {'type/Number': {'avg': 0,
'max': 0,
'min': 0,
'q1': 0,
'q3': 0,
'sd': 0}}},
'name': 'invitations_count',
'semantic_type': 'type/Quantity'},
{'base_type': 'type/Integer',
'display_name': 'decidim_organization_id',
'effective_type': 'type/Integer',
'field_ref': ['field',
'decidim_organization_id',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 0},
'type': {'type/Number': {'avg': 1,
'max': 1,
'min': 1,
'q1': 1,
'q3': 1,
'sd': 0}}},
'name': 'decidim_organization_id',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'confirmation_token',
'effective_type': 'type/Text',
'field_ref': ['field',
'confirmation_token',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1778,
'nil%': 0.002805836139169473},
'type': {'type/Text': {'average-length': 19.94388327721661,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'confirmation_token',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'confirmed_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'confirmed_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1124,
'nil%': 0.3698092031425365},
'type': {'type/DateTime': {'earliest': '2021-01-25T12:32:03.153468+01:00',
'latest': '2021-07-14T08:12:05.904057+02:00'}}},
'name': 'confirmed_at',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'confirmation_sent_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'confirmation_sent_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1778,
'nil%': 0.002805836139169473},
'type': {'type/DateTime': {'earliest': '2021-01-20T13:39:35.028644+01:00',
'latest': '2021-07-20T11:23:55.095673+02:00'}}},
'name': 'confirmation_sent_at',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'unconfirmed_email',
'effective_type': 'type/Text',
'field_ref': ['field',
'unconfirmed_email',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 8,
'nil%': 0.9960718294051627},
'type': {'type/Text': {'average-length': 0.0931537598204265,
'percent-email': 0.003928170594837262,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'unconfirmed_email',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'name',
'effective_type': 'type/Text',
'field_ref': ['field',
'name',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1750,
'nil%': 0},
'type': {'type/Text': {'average-length': 10.878226711560044,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'name',
'semantic_type': 'type/Name'},
{'base_type': 'type/Text',
'display_name': 'locale',
'effective_type': 'type/Text',
'field_ref': ['field',
'locale',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0.003367003367003367},
'type': {'type/Text': {'average-length': 1.9932659932659933,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'locale',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'avatar',
'effective_type': 'type/Text',
'field_ref': ['field',
'avatar',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 147,
'nil%': 0.9152637485970819},
'type': {'type/Text': {'average-length': 1.7480359147025815,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'avatar',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'delete_reason',
'effective_type': 'type/Text',
'field_ref': ['field',
'delete_reason',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0.9966329966329966},
'type': {'type/Text': {'average-length': 0,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'delete_reason',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'deleted_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'deleted_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 7,
'nil%': 0.9966329966329966},
'type': {'type/DateTime': {'earliest': '2021-01-22T15:39:16.85799+01:00',
'latest': '2021-04-16T13:37:52.797992+02:00'}}},
'name': 'deleted_at',
'semantic_type': 'type/DeletionTimestamp'},
{'base_type': 'type/Boolean',
'display_name': 'admin',
'effective_type': 'type/Boolean',
'field_ref': ['field',
'admin',
{'base-type': 'type/Boolean'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 0}},
'name': 'admin',
'semantic_type': None},
{'base_type': 'type/Boolean',
'display_name': 'managed',
'effective_type': 'type/Boolean',
'field_ref': ['field',
'managed',
{'base-type': 'type/Boolean'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 0}},
'name': 'managed',
'semantic_type': None},
{'base_type': 'type/*',
'display_name': 'roles',
'effective_type': 'type/*',
'field_ref': ['field', 'roles', {'base-type': 'type/*'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 0}},
'name': 'roles',
'semantic_type': None},
{'base_type': 'type/Boolean',
'display_name': 'email_on_notification',
'effective_type': 'type/Boolean',
'field_ref': ['field',
'email_on_notification',
{'base-type': 'type/Boolean'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0}},
'name': 'email_on_notification',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'nickname',
'effective_type': 'type/Text',
'field_ref': ['field',
'nickname',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1777,
'nil%': 0},
'type': {'type/Text': {'average-length': 8.751402918069585,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0.001683501683501684,
'percent-url': 0}}},
'name': 'nickname',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'personal_url',
'effective_type': 'type/Text',
'field_ref': ['field',
'personal_url',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 183,
'nil%': 0.8956228956228957},
'type': {'type/Text': {'average-length': 4.216049382716049,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0.1043771043771044}}},
'name': 'personal_url',
'semantic_type': 'type/URL'},
{'base_type': 'type/Text',
'display_name': 'about',
'effective_type': 'type/Text',
'field_ref': ['field',
'about',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 187,
'nil%': 0.8181818181818182},
'type': {'type/Text': {'average-length': 40.59652076318743,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'about',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'accepted_tos_version',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'accepted_tos_version',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0.001122334455667789},
'type': {'type/DateTime': {'earliest': '2021-01-13T11:23:17.892+01:00',
'latest': '2021-01-13T11:23:17.892+01:00'}}},
'name': 'accepted_tos_version',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'officialized_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'officialized_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 1},
'type': {'type/DateTime': {'earliest': None,
'latest': None}}},
'name': 'officialized_at',
'semantic_type': None},
{'base_type': 'type/Structured',
'display_name': 'officialized_as',
'effective_type': 'type/Structured',
'field_ref': ['field',
'officialized_as',
{'base-type': 'type/Structured'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 1},
'type': {'type/Text': {'average-length': 0,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'officialized_as',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'newsletter_token',
'effective_type': 'type/Text',
'field_ref': ['field',
'newsletter_token',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 0},
'type': {'type/Text': {'average-length': 0,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'newsletter_token',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'newsletter_notifications_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'newsletter_notifications_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 946,
'nil%': 0.4696969696969697},
'type': {'type/DateTime': {'earliest': '2021-01-22T15:22:36.200567+01:00',
'latest': '2021-07-20T11:23:54.951316+02:00'}}},
'name': 'newsletter_notifications_at',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'type',
'effective_type': 'type/Text',
'field_ref': ['field',
'type',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0},
'type': {'type/Text': {'average-length': 13.002805836139169,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'type',
'semantic_type': 'type/Category'},
{'base_type': 'type/Structured',
'display_name': 'extended_data',
'effective_type': 'type/Structured',
'field_ref': ['field',
'extended_data',
{'base-type': 'type/Structured'}],
'fingerprint': {'global': {'distinct-count': 26,
'nil%': 0},
'type': {'type/Text': {'average-length': 2.5942760942760943,
'percent-email': 0,
'percent-json': 1,
'percent-state': 0,
'percent-url': 0}}},
'name': 'extended_data',
'semantic_type': None},
{'base_type': 'type/Integer',
'display_name': 'following_count',
'effective_type': 'type/Integer',
'field_ref': ['field',
'following_count',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 34,
'nil%': 0},
'type': {'type/Number': {'avg': 1.5291806958473626,
'max': 136,
'min': 0,
'q1': 0,
'q3': 1.3449156655754309,
'sd': 5.138398051270926}}},
'name': 'following_count',
'semantic_type': 'type/Quantity'},
{'base_type': 'type/Integer',
'display_name': 'followers_count',
'effective_type': 'type/Integer',
'field_ref': ['field',
'followers_count',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 6,
'nil%': 0},
'type': {'type/Number': {'avg': 0.04826038159371493,
'max': 6,
'min': 0,
'q1': 0,
'q3': 0.32291551924533135,
'sd': 0.3383163445768285}}},
'name': 'followers_count',
'semantic_type': 'type/Quantity'},
{'base_type': 'type/Text',
'display_name': 'notification_types',
'effective_type': 'type/Text',
'field_ref': ['field',
'notification_types',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 4,
'nil%': 0},
'type': {'type/Text': {'average-length': 3.0347923681257014,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'notification_types',
'semantic_type': None},
{'base_type': 'type/Integer',
'display_name': 'failed_attempts',
'effective_type': 'type/Integer',
'field_ref': ['field',
'failed_attempts',
{'base-type': 'type/Integer'}],
'fingerprint': {'global': {'distinct-count': 6,
'nil%': 0},
'type': {'type/Number': {'avg': 0.03984287317620651,
'max': 6,
'min': 0,
'q1': 0,
'q3': 0.3126278666391992,
'sd': 0.3435220325740906}}},
'name': 'failed_attempts',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'unlock_token',
'effective_type': 'type/Text',
'field_ref': ['field',
'unlock_token',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 1},
'type': {'type/Text': {'average-length': 0,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'unlock_token',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'locked_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'locked_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 1,
'nil%': 1},
'type': {'type/DateTime': {'earliest': None,
'latest': None}}},
'name': 'locked_at',
'semantic_type': None},
{'base_type': 'type/DateTime',
'display_name': 'admin_terms_accepted_at',
'effective_type': 'type/DateTime',
'field_ref': ['field',
'admin_terms_accepted_at',
{'base-type': 'type/DateTime'}],
'fingerprint': {'global': {'distinct-count': 5,
'nil%': 0.9977553310886644},
'type': {'type/DateTime': {'earliest': '2021-01-28T09:52:03.979123+01:00',
'latest': '2021-01-28T11:03:03.269947+01:00'}}},
'name': 'admin_terms_accepted_at',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'session_token',
'effective_type': 'type/Text',
'field_ref': ['field',
'session_token',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 232,
'nil%': 0.8703703703703703},
'type': {'type/Text': {'average-length': 4.148148148148148,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'session_token',
'semantic_type': None},
{'base_type': 'type/Text',
'display_name': 'direct_message_types',
'effective_type': 'type/Text',
'field_ref': ['field',
'direct_message_types',
{'base-type': 'type/Text'}],
'fingerprint': {'global': {'distinct-count': 2,
'nil%': 0},
'type': {'type/Text': {'average-length': 3.0561167227833894,
'percent-email': 0,
'percent-json': 0,
'percent-state': 0,
'percent-url': 0}}},
'name': 'direct_message_types',
'semantic_type': None}],
'table_id': None,
'updated_at': '2022-02-18T17:46:10.527405Z',
'visualization_settings': {'table.cell_column': 'id',
'table.pivot_column': 'reset_password_token'}}