Abstract: A computer system may be provided. The computer system may include at least one processor programmed to: (a) receive an input defining (i) at least one specified dataframe, (ii) one or more query filters, and (iii) one or more sets of one or more columns, each of the sets associated with at least one of the query filters; (b) generate a first map identifying (i) a list of non-nested columns of the at least one specified dataframe, and (ii) a list of nested columns of the at least one specified dataframe; (c) generate a second map including (i) the query filters associated with the set (ii) a list of non-nested columns, and (iii) a list of nested columns; and/or (d) generate an exploded dataframe from the at least one specified dataframe at least in part by exploding at least one nested column from the list of nested columns.

Abstract: Systems and methods for using active directory dynamic group membership engines to grant access are disclosed. In one embodiment, in an active directory dynamic group membership engine comprising at least one computer processor, a method for using active directory dynamic group membership engines to grant access may include: (1) receiving from a user electronic device, a request for privileged access to access a resource; (2) decisioning and granting the request for privileged access to the resource; (3) adding the user to an active directory group for privileged access to the resource, wherein the privileged access is limited to a time period; and (4) removing the user from the active directory group for privileged access upon expiration of the time period.