Building a Data Stack Live with AI AgentsLivestream August 18

Skip to main content

MD_SET_GUIDE_ACCESS

Preview
This feature is in preview and is subject to change.

Change a Guide's visibility to 'user' (private) or 'organization' (visible to your whole org). Setting org-wide access is admin-permission gated.

Syntax

SELECT * FROM MD_SET_GUIDE_ACCESS(
id = '<guide_uuid>',
access = 'organization'
);

Parameters

ParameterTypeRequiredDescription
idUUIDYesThe guide's UUID.
accessVARCHARYes'user' (private) or 'organization' (org-wide, admin-permission gated).

Return columns

ColumnTypeDescription
idUUIDGuide UUID
topicVARCHARGrouping label (NULL for guides without a topic)
titleVARCHARGuide title
descriptionVARCHAROne-line summary
owner_idUUIDUUID of the guide owner
owner_nameVARCHARName of the guide owner
accessVARCHARUpdated access level
current_versionUINTEGERLatest version number
created_atTIMESTAMP WITH TIME ZONEWhen the guide was created
updated_atTIMESTAMP WITH TIME ZONEWhen the guide was last updated

Examples

Publish a guide to the whole org:

SELECT access
FROM MD_SET_GUIDE_ACCESS(
id = 'a1b2c3d4-e5f6-7890-abcd-ef1234567890',
access = 'organization'
);

Make a guide private again:

SELECT access
FROM MD_SET_GUIDE_ACCESS(
id = 'b2c3d4e5-f6a7-8901-bcde-f12345678901',
access = 'user'
);